why date filter is not working? When I chose last 7 days, it doesn't filter data.

Options
Jay.p
Jay.p Member
in Dashboards

Can someone explain why date filter is not working? When I chose last 7 days, it doesn't filter data.
7 days total revenue is not loading and not filtering data in the table.

Screenshot 2025-05-01 020503.png Screenshot 2025-05-01 014946.png
Tagged:

Answers

  • MichelleH
    MichelleH Coach

    @jhp Do you have the date range hidden on your revenue cards? If this box is checked in Analyzer, then the card will not react to dashboard date filters.

    image.png
  • Jay.p
    Jay.p Member

    May be no!

    1. From "Date Presets"

    image.png


    2. From "Revenue"

    image.png
  • MichelleH
    MichelleH Coach

    I'm assuming the "Date Presets" card is a Date Selector filter card. Do the "Date Presets" and "Revenue" cards use the same dataset? If no, they both need to contain date columns with the same name in order for the filter interactions to work.

  • Jay.p
    Jay.p Member

    Yes, both are using same data set!

    1. Date Presets

    Screenshot 2025-05-01 102339.png


    2. Revenue

    Screenshot 2025-05-01 102533.png
  • MichelleH
    MichelleH Coach

    @Jai Based on your screenshots, it appears that your "Date" field is being stored as a string instead of a date (you should see a calendar icon instead of "ABC"), so Domo doesn't know how to filter the data.

    image.png

    To resolve this, you either need to change that field's datatype your source data or use a beast mode like this in your cards:

    CAST(`Date` as date)
  • Jay.p
    Jay.p Member

    @MichelleH That works, thanks a million for helping me!

Categories