I'm not sure what you mean when you say, "We know that the drill option is available in tables. But, unfortunately, once you make a graph you cannot really drill-down within a category."
By creating a hierarchy, you can drill down from region to sub-region for both tables and graphs. If you don't want to expand all of the regions, then creating a second sheet at the sub-region level that is filtered by the region selection might work.
Attached is an example.
- You can drill down using the hierarchy method by clicking on the + sign next to state or by right-clicking on the state and choosing "drill down"
- You can drill down using the filter method by clicking on the state name.
drilldown.twbx.zip 189.1 KB
thanks for your answer. Indeed, it is possible to drill down when you have the dimension on the y-axis, as in your example. But we want to display data within a bar chart that would look like the one I have attached. Our aim is to double click in one of the colors and then the next level of hierarchy is displayed in the same way (sort of zooming in) . At the moment if you just click in one of the colors you only get the 2 default options "keep" or "exclude" .
You could still do it with actions and a worksheet or dashboard for each level of detail. Clicking on a Category in Dashboard 1 takes you to the sub-category level in Dashboard 2. ...
drilldown_v2.twbx.zip 1.2 MB
Hi Jim Wahl,
I have been looking for this type of drill down functionality for some time now , so was really happy to come across your solution.
just one point though , is it possible to do the same implementation using different worksheets which can be hidden , instead of placing each detail report in a new dashboard which is visible in the server.
My requirement has 7 reports in one dashboard , and all 7 should have a similar drill down functionality .
so not sure how this can be done. is there an alternate way of having each detail report in a new worksheet . which would be hidden until clicked on ??
thanks in Advance,