I like JTD well enough. It's a great solution for dimensional slicing. I am also a fan of the Tabber widget for this reason but on a smaller scale, although I do have to keep in mind the number of widgets I cram in to each Tab as it can impact speed. I'm currently using Tabber to do comparisons between different KPIs, but have used JTD in the past as a quicker scripting workaround for unit conversions ... # v % is one example, since the calcs are drastically different in my case; it would have been too much to cram them all in one dashboard and subsequently hide what's irrelevant like with Tabber. And I will say Tabber exports to PDF can be wonky, so if that's the intended mode of consumption, be sure to tweak the preview and save it! 🙂
JTD has been a lifesaver in the respect of presenting details, indeed, because it often allows me to just present a table with the data organised in a way that a drilldown in a pivot just will not allow.
This will also make it easier to download that data, but with large tables the opportunity to explore data in the dashboard is quite limited. It feels like doing this is giving up and just presenting the data for my users to analyse in, for example, Excel.
Filtering is another option. Another way I've tried to cram details in our dashboards is by making extensive use of 'affects dashboard filters' functionality in bar/pie chart widgets to present the top x most interesting values to potentially filter on and surface details that way, but I'm left wondering if my users notice and *use* those filters, or all that detail is left languishing.
have you thought about explicitly noting the ability to filter using the 'affects dashboard filters'. One thing I'm doing more of these days is providing text boxes with guidance on how to use the dashboard, key things they should know. Recording a quick video could help too. I know that's not really about the widgets or visualizations themselves, but I'm increasingly focused on the guidance/training in the vehicle if I can.
Love this idea!!
