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.