How to Choose a Measure to Display Dynamically

Knowledge Drop

Last Tested: Jan 21, 2019

Let's say I have a dimension that I want to see multiple aggregations for one at a time!

We can create a parameter with n number of allowed values depending on the number of measures you wish to display:

Screen Shot 2019-01-11 at 2.16.18 PM.png

From here, we can create a measure with liquid that listens to the parameter value declared above and then chooses the corresponding measure to display:

Screen Shot 2019-01-11 at 2.19.07 PM.png

You can then add the dimension and dynamic measure to an explore, save it to a dashboard, and then add a dashboard filter on that parameter:

Screen Shot 2019-01-11 at 2.21.40 PM.png

You should then see similar functionality to this:

Dynamic Pie Chart.gif

Congratulations! You've now made a dynamic measure that users can interact with! 🙂

Comments
albronca
New Member

think this is what I’m trying to accomplish, but the image tags in the post seem to be broken. Any chance you still have the image files available/can update the post with them.

Thanks!

Version history
Last update:
‎04-05-2021 12:37 PM
Updated by: