Thanks to this community, I have been connected with a ton of helpful information about how to manage graph content on a dashboard: This one about using containers to swap out charts is particularly interesting for my purposes.
I would like to know if it's possible to combine the parameter-driven swap in that example (or something like it) with a more basic filter-driven data change. I know that probably doesn't make sense, so I'll try to explain a simplified version of my challenge.
- I need to create a dashboard to display performance measure data. The data is already hierarchically/semantically organized, so that I need to keep related measures in the same dash regardless of data and chart type.
- Many measures are percentage-based, many are integer, and some are currency. Integers and currency must be displayed with column charts, and percent charts must use lines. All will need correct y-axis formatting.
As an example, let's say I have a performance category with nine submeasures. Of these, three are percentages, three are integers, and three are currency.
- If I were to create a basic filter on the submeasure, I could easily swap out the underlying data using only one underlying graph--but then all data would display with the same data type (eg integers and $ would look like %s), which would be wrong.
- If I were to use the nifty parameter trick above, I could easily swap out the three types of charts. However, it looks like I'd be stuck making nine separate source graphs instead of three, which is super inefficient (because I actually have way more than nine measures). Also, it looks like each graph that gets dropped into a container a la that same nifty method creates some padding. Three sets of padding might go unnoticed, but nine sets is going to be a problem.
Is there a way to combine these strategies, so that I have three parameter-driven graphs that swap out, each of which can toggle through three different datasets using a drop-down? If so, is there a way to get all those choices into the same drop-down so that the different sources are not apparent to the user? The user should feel that she gets to choose between nine options, only one of which should display at a time.
Here's a sample of what it needs to look like--except that the dropdown would need to provide additional choices that use alternate chart/number format types. (That one uses a basic filter, not a parameter).
Thanks a ton!