Dashboard filters of dynamically changing Measures and Dimensions
Beginner | 10 Minutes
Overview
Interactivity allows users to explore data dynamically, uncover insights, and make informed decisions more effectively. Interactive elements enable users to customize their view, focus on specific data points, and discover trends or anomalies that might not be evident in static reports. This enhances user engagement, making the dashboard a tool for displaying information and a platform for data-driven exploration and decision-making.
This tutorial walks you through how to add interactivity to a dashboard by allowing the user to choose the attribute and/or measure they want to concentrate on.
📋 Requirements
|
Tutorial
1
Create an embedded filter
The video below shows you how to create a filter with parameters that use the measures.
2
Create a saved expression
In Visualizer, Advanced Tools/BQL Editor, create a Saved Expression that will collect and interpret the values from the parameter.
- GetPromptValue captures the value provided by the parameter called Value Selector, as a string.
- If the parameter is empty, then a default string is used, in this case
[OrderDate: # Distinct CustomerID]. <EVAL!evaluates the string as a Measure or Dimension.
Finally, use the newly created Saved Expression in your report as a regular Measure or Dimension.
3
Test the filters
- The user will make a selection on the embedded filter.
- Based on the user’s selection, the filter will generate the corresponding parameter.
3. The GetPromptValue function will capture the value from the parameter, and <EVAL! will convert the captured string to a Measure or Dimension.
Resources
On this page
- Dashboard filters of dynamically changing Measures and Dimensions