tip 02 – how to add dashboard filters

tip 02 – how to add dashboard filters
level: easy

This video will show you how to add two dashboard buttons to an existing chart. Note how these buttons filter the data that is displayed in the chart. Also note that the global application filters (list boxes) determine the values that are displayed as avaialble buttons.

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:

  • show how the chart responds to two filters (buttons) and how these filters respond to the settings of the global application filter;
  • add a MDX filter and base it on the Customer Country hierarchy, set the filter to horizontal buttons and assign the filter the event value “@{country}” with all countries selected as default;
  • add a second MDX filter to select years as buttons, base it on the Calendar Year, and only display years with data for “Internet Sales Amount”, set the filter event to “@{year}” with all years selected as default;
  • update the serial bar char underlying data definition and add as filter the @{year} and change the Customer Country hierarchy to the @{country} filter;
  • save and publish to the application;
  • see how the chart responds to the filter settings and how these respond to the global filters Calendar Year and Country.

Below the interesting highlights of the tip, so you can have a closer look.

If you want to learn more on events and how you could use these to improve your user experience in dashboards, read here.

Back to dashboard tips.