Apps

Apps

Filtering inside a DDX Brick

Member

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!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answers

  • Answer ✓

    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?

    If I solved your problem, please select "yes" above

  • Domo Employee
    Answer ✓

    Information on filtering can be found here DOMO Developer

Answers

  • Answer ✓

    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?

    If I solved your problem, please select "yes" above

  • Contributor

    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.

  • Domo Employee
    Answer ✓

    Information on filtering can be found here DOMO Developer

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In