I am putting some charts into the app to allow users to filter results based on a the current date less a number of days. I built an option set that allows a user to pick 30 days, 60 days, 90 days, etc. and added an attribute that is the number of days.
The objective is to add the filers in the Do A Search for data source that feeds the chart. When I go to add the filters they are dimmed out with a grey-on-grey message in 5-point font that cannot be read (bubble UI) but the filters cannot be selected.
I grouped the filters and chart together thinking that might help but no dice. Any thoughts on how to apply the filters? They cannot be applied in conditionals for the chart either.
Hi there,
What datatype are those fields you’re trying to filter by, and what datatype is your dropdown?
The one on the right are the offer status for the offers data and the chart is offers data. What I am trying to do is create predefined set of days to look back onand filter the offers (e.g 30 days back, 60 days back etc) so thedropdown on the left is an option set called Date Filters. And the container is source: Offers.
So I ant the do a Search For offers createDate => dateFilters Attribute
And Bubble hates that Date Filter is not Offers.
Yeah I believe this is the crux of the problem. I would recommend looking at your Option Sets and making sure the fields are set properly - so if they’re dates, make sure the fields are designated as a Data type. And then the same thing with the offerCreateDate field on your Offers datatype.
They are not a date type - the options are:
30 Days (Display) Attribute 30
60 Days (Display) Attribute 60
…
180 Days (Display) Attribute 180
and I am expecting:
Do A Search For Offers
merchant= current users merchant
offerCreateDate => Current Date/Time - ddwn DateFilters Attribute: 30
Passing the number of days back to filter the offer data using the Option Set,.
