how to use slider instead of hard coded value in text object

[#1]

Hi All

i am using

=Concat(If(Aggr(rank(Sum(Aggr(Count({<HourFLag={'Violation'}>}[Employee id]),[Employee id],Date))),[Employee id])<=3,[Employee id]),Chr(13))

inside text object

here i want to use slider instead of hard coded value  (here it is <=3) how to get this

Regards

hemesh

[crusader_ · Accepted solution]

Hi,

1. Create variable vTo=3 (for example).

2. Create Slider object and choose Mode = Single Value, Data = Variable vTo

3. Set limits and step

4. Change your expression

=Concat(If(Aggr(rank(Sum(Aggr(Count({<HourFLag={'Violation'}>}[Employee id]),[Employee id],Date))),[Employee id])<=$(vTo),[Employee id]),Chr(13))

That's it.

Hope it helps.

Regards,

Andrei