Skip to content

    • Charting

    Charting

    Drill path Grayed Date Range

    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

    • 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

      1. 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! **

    • 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

    • 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

      1. 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! **

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories