How do I create a drill path for a stacked bar chart with multiple measures/values?
I'm new to Domo and spent some time digging around the Dojo to try to find the answer to this question but didn't have any luck... I hope what I'm asking for makes sense; I'm happy to provide details if it doesn't.
Thank you in advance for your help!
I created a line and stacked bar chart where the series (the bar pieces) are made up of three measures/values. When I click on one of the series, I want to be taken into that data and shown a slightly different view; however, I'm struggling to make a drill path that gives me what I want because the drill path isn't filtering out the other two measures/values.
The line and stacked bar chart shows inventory (in buckets) by month. The x-axis is the month; the y-axis is a calculated field (don't think it's relevant to solving the problem), and the series are three different inventory buckets, which are measures. I want to click into an inventory bucket and have the drill path filter out the other two measures or I want the y-axis to be variable depending on which inventory bucket I clicked into. If it helps, the drill path is a stacked bar chart (the series (i.e. the bar pieces) in this chart are not inventory buckets, they're categories).