Drill path Grayed Date Range

Josh_Evans20
Josh_Evans20 Member
in Charting

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.

image.png

Answers

  • ArborRose
    ArborRose Coach

    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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • MichelleH
    MichelleH Coach

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

Categories