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

Best Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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
    Answer ✓

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

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    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
    Answer ✓

    @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