Drill path Grayed Date Range

Josh_Evans20 · 2024-10-14T18:19:19+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

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.

All comments

ArborRose

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.