Trigger Multiple Drill Downs On a Page At The Same Time

Hello all,


Is there a way to trigger multiple drill downs at the same time on a page? The idea here is to have a kpi page where we can see things on a daily, weekly, and monthly level. So if the page were to start with a daily view to then be able to drill to weekly, then drill to monthly, but when triggered to also drill all the other cards, so all the data is viewed at the same drill path level.

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

    Instead of trying to use drill paths to solve this problem, could you use filters?

     

    could you structure data where you have a column where you pick between 'day, month, and quarter' which then filters the data to the range of dates you're interested in seeing?

     

    if you must have different views with different groupings in the cards, could you have a summary page that has links to different views of the dashboard aggregated to different level (dashboard_by_week, dashboard_by_month) etc?

     

    as you deliver this, take the time to think, what metrics become more or less important as i visualize the trend at a week or a month level.  who is going to look at this?

     

    the guy who looks at activity in the last week is probably a line of business worker and therefore has different questions and interests compared to the manager who is looking at a month over month or quarterly trend.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • For additional context, the change wouldnt just be to how the dates are grouped but the date range would change as well. On a daily level I would likely look at only one week, from a weekly level likekly 12 weeks, and the monthly view would be over 12 months. 

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach
    Answer ✓

    Instead of trying to use drill paths to solve this problem, could you use filters?

     

    could you structure data where you have a column where you pick between 'day, month, and quarter' which then filters the data to the range of dates you're interested in seeing?

     

    if you must have different views with different groupings in the cards, could you have a summary page that has links to different views of the dashboard aggregated to different level (dashboard_by_week, dashboard_by_month) etc?

     

    as you deliver this, take the time to think, what metrics become more or less important as i visualize the trend at a week or a month level.  who is going to look at this?

     

    the guy who looks at activity in the last week is probably a line of business worker and therefore has different questions and interests compared to the manager who is looking at a month over month or quarterly trend.

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.