Filtering inside a DDX Brick

ColinHaze

Hi,

I am currently trying to filter on the date inside my DDX brick to only give me the current month data. The date Column I am using to filter is called Fiscal Months. How would I do that? Im assuming it has to do with the way im querying the dataset. I attached my JS below. One thing to Note is that date column is always going to be the first of a month. For example
2023-11-01
2024-05-01
2024-05-01
2024-01-01
2023-08-01
2023-11-01

Thanks a lot in advance!

ColemenWilson

I don't know anything about Javascript but have you considered filtering the data through an ETL/Dataset View to current month data if that is all you need for the DDX brick?

JosephMeyers

Information on filtering can be found here https://developer.domo.com/portal/6fa7587d4c2ea-querying-data#filters

ColemenWilson

I don't know anything about Javascript but have you considered filtering the data through an ETL/Dataset View to current month data if that is all you need for the DDX brick?

Sean_Tully

I think you can add 'filter=Fiscal Months = [current month]&' after the '?' in your query definition, but I don't know JS enough to know how to create that [current month] value.

You can also do the filter via ETL/View before it hits the app like @ColemenWilson suggested, or I think you can just add the filter at the time you build a new card off of the app.

JosephMeyers

Information on filtering can be found here https://developer.domo.com/portal/6fa7587d4c2ea-querying-data#filters

ColinHaze

@ColemenWilson I ending up doing it your way. Thank you