tip 11 – how to create a dynamic split-by chart
tip 11 – how to create a dynamic split-by chart
level: easy
Good dashboards have the right balance between flexibility and user experience. This tip will show you how to add extra flexibility to a dashboard by allowing the user to choose what information is displayed in the charts.
It is a very nice functionality, but please be careful not to overdo it, as it could overwhelm your audience if used too much.
It’s an “up-tempo” video, you might want to pause a couple of times if you want to study the steps.
Timeline and topics:
- The end-result shows a dashboard that allows a user to select which information is displayed in the bar-chart;
- Notice how the chart labels change when a different “axis” is selected in the button list;
- To create this, start by adding a “MDX Filter” and give it a title;
- Select the data layer, and click on “Manual”;
- next, select the desired hierarchy levels from the available Suggestions;
- the demo just picks a couple for illustration purposes;
- set one of the items to “Selected”, in this case it is “City”;
- next, open the events panel and name the “on Selection” event “@{row}”;
- Now, create a new serial chart;
- and set the data layer with “Internet Sales Amount” as the measures;
- and the “@{row}” parameter as Rows;
- set Order descending on the amount;
- In the Data Render panel, set the Chart Type to clustered Bar;
- and add a Scrollbar that zooms in to the first 10 items;
- beatify the numeric formatting;
- set the series color;
- add a cursor for additional information;
- and improve the balloon text;
- save, verify that it works;
- place the report in the application (tip 07) and you’re done.
Back to dashboard tips.