Finding Values with slider or input box

[#1]

I am trying to supplement a straight table that has Users and total spend along with multiple other fields in it. Is it possible to have a slider or input box (ideally both) that I type or slide to a value say $100, and it will show all the users that have $100 spend instead of changing the actual spend to $100?

[sunny_talwar]

Probably this:

If(Yourexpression = $(vVar), yourexpression)

where vVar is based on your slider or input box object.

HTH

Best,

Sunny

[#3]

Embed that if statement in the straight table? and create a vVar for the slider or input box?

[sunny_talwar]

Yes, I am trying to see if I can create a sample for you.

[sunny_talwar]

See if the attached helps.

Best,

Sunny

[#6]

Thanks Sunny, I think this will work, but I want to show all users over $75, $100, $ 150 by the slider and input, sorry I didn't specify, this might make things more difficult?

[sunny_talwar]

Change the expression to this:

=If(Sum(Value) >= vVar, Sum(Value))

[cbaqir]

How would this work if you are using multi value in the slider? I need to enter a start and end date.

[sunny_talwar]

‌Should be straight forward if I am thinking about it correctly.

If(Date >= vStartDate and Date <= vEndDate, yourExpression)

[cbaqir]

Gantt and Straight table by Input Box Date Range

Sunny, Mind if I ask you to weigh in on this?