Applying Filters to Charts

chris.e.daly · 2024-10-01T10:48:51.565Z

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.

Screen Shot 2024-10-01 at 6.41.19 AM1920×1553 129 KB

Screen Shot 2024-10-01 at 6.41.57 AM1384×2094 222 KB

msgiblin · 2024-10-01T14:29:22.859Z

Hi there,

What datatype are those fields you’re trying to filter by, and what datatype is your dropdown?

chris.e.daly · 2024-10-01T21:05:21.782Z

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.

msgiblin · 2024-10-01T21:23:56.726Z

chris.e.daly:

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.

chris.e.daly · 2024-10-01T21:39:49.378Z

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,.

system · 2024-12-10T10:49:40.184Z

This topic was automatically closed after 70 days. New replies are no longer allowed.