Knowledge Drop

How to Choose a Measure to Display Dynamically

  • 5 April 2021
  • 1 reply
  • 46 views

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! :)

 


1 reply

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!

Reply