Skip to content

    • Apps

    Apps

    Filtering inside a DDX Brick

    Member
    in Apps

    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!

    image.png

    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

    • Coach
      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

    • Coach
      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

    • Member

      @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

    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

    Quick Links

    Categories