How to set the default filter column in drill path second level

Team,

good day,

kindly advise, how can we set the default filter in the second level of drill down in drill path?
1. First level we are using few columns in Table card like -ID, Name, Subject and so on.

2. By default the Unique ID column which is not used in first level should be filtered in second level when we click on any of columns in the first level.

Kindly suggest.

regards

M. Vijay Antony

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Due to how Drill Paths work it will automatically filter the column you select. There isn't a way to force Domo to filter your drill path based on a specific value in the row's data. I'd recommend logging an idea in the idea exchange to allow you to select which field would be used for the drill path filtering.

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

Answers

  • This happens automatically when you drill down. You can apply additional filters to the drill path in the drill path editor. Here is a KB article that walks through the steps of adding a drill path: https://domo-support.domo.com/s/article/360042924094#add_a_drill_path_to_a_chart

    If I solved your problem, please select "yes" above

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Due to how Drill Paths work it will automatically filter the column you select. There isn't a way to force Domo to filter your drill path based on a specific value in the row's data. I'd recommend logging an idea in the idea exchange to allow you to select which field would be used for the drill path filtering.

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

    GrantSmith was right, We can't force the DOMO to filter the specific column values during the drill path, Columns are clicked in the first level are only being passed as a filter values to second level.

    Thanks

    M. Vijay Antony