Filter by on expression

[#1]

I have a single chart as this one:

Customer A **************** 35 %

Customer B ************** 30 %

Customer C ******** 10 %

Customer D ***** 7 %

...

PCT Discount expression is some thing like sum( discount ) /  ( sum( price ) + sum( discount ) )

At this time, I want to filter chart to see only clients with a PCT Discount < X. How can I create a slider object to select X ?

This is my first question. Sorry if I have contravened any etiquette rule.

[martin59 · Accepted solution]

Hi Daniel,

First, if you want to use a slider object, you must create a variable.

So, go to Settings / Variable overview  and add a new variable called vLimit.

After that, you have to create a new "Slider / Calendar object".

Let the input type as slider, choose your variable and set the options like in the picture.

Hope that helps you,

Martin Favier

[#3]

Thanks Martin,

runs like a charm:

Also important to set limit to var in chart limits dimension properties:

daniel.