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

Jai

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.

MichelleH

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

Jai

May be no!

1. From "Date Presets"

2. From "Revenue"

MichelleH

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.

Jai

Yes, both are using same data set!

1. Date Presets

2. Revenue

MichelleH

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

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)

Jai

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