Sliders and Contextual Measures

#1

Hello,

I am looking to create a slider that modifies a contextual measure between 0 to 1 for percentage multipliers for a dashboard. Can anyone share any insight onto how to have your slider update a contextual measure?

#2

You can create a calculated measure formula which references a parameter placeholder.

The calculated measure formula references the value of a parameter that you set up for this purpose. Then you use the slider to control that parameter.

#3

Thanks David,

So I have been able to get it to the point where I have my slider and placeholder. The area I am having issue at is using the slider to control the parameter. Is there a script that needs to be behind the slider?

#4

Hi Patrick,

Based on my understanding of your use case, you already have a placeholder created in the calculated measure of your metric set. Now you want to link this to your slider filter.
To do this select your slider filter and then click on connect filter:
image

Now expand the calculated measure that has the placeholder. Assuming your placeholder is of type single number. Connect the filter to this placeholder:

image
image.png802×507 16.1 KB

So, now your placeholder will get the value selected using the slider filter:

image
image.png838×560 7.66 KB

I hope this answers your question. Let me know in case you have any questions about this.

Regards,
Pankaj

3 Likes
#5

Hello Pankaj,

That worked thank you. When I tried this on my own I got to the point where you connected the filter. instead of drilling down and picking single number I picked the group so it filtered out the table to be blank. What is the difference between the two values you can select Constant and the one you selected (Single Number)

#6

Hi Patrick,

I am glad that worked. In this case, we have a formula measure named “Constant” that has a single number placeholder.
So, when you add a numeric filter like the slider filter, it gives you an option to either connect to the actual measure (AllNumber) or the placeholder (SingleNumber).
The difference between the 2 is if you connect it to the (AllNumber) or the group itself, it would be used as a filter i.e. the value that you select in the slider will be then used to filter the metric set to which the filter is attached to. Whereas, if you connect it to the placeholder (SingleNumber) this would just assign the selected value to the parameter rather than filtering the data set.

3 Likes
#7

Got it,

This makes sense thank you for the explanation Pankaj

#8

And the beauty of it is that your formula can have multiple placeholders, each controlled by a different slider or filter.

1 Like