Drill path Grayed Date Range

Josh_Evans20

I'm working on creating a drill path that will filter down to the last 9 days. When I go into it the date range option is grayed out.

ArborRose

It may be that Domo does not recognize the date field. You can go to the schema and check the data types to make sure the field you are using is a Date type. For filter, you can use a calculation such as

CASE WHEN `Date` >= CURRENT_DATE() - INTERVAL 9 DAY THEN 'Last 9 Days' ELSE 'Other' END

MichelleH

@Josh_Evans20 It's greyed out on the drill path because it inherits the date range from the top level card, like other drill filters.

ArborRose

It may be that Domo does not recognize the date field. You can go to the schema and check the data types to make sure the field you are using is a Date type. For filter, you can use a calculation such as

CASE WHEN `Date` >= CURRENT_DATE() - INTERVAL 9 DAY THEN 'Last 9 Days' ELSE 'Other' END

MichelleH

@Josh_Evans20 It's greyed out on the drill path because it inherits the date range from the top level card, like other drill filters.