Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have 2 input box in my dashboard, the user will write a min and max value of the "TotalCosts" and the dashboard will show only values between these 2 values.
Hi Valeria.
With the two input boxes, I would store their values into two variables (vMin and vMax).
In the table expression, I would have a formula like this:
if( ($(vMin) < Sum([Field])) and (Sum([Field]) < $(vMax)),
Sum([Field])
)
I don't like the fact of using the if() function, which can result in performance loss on chart calculation, depending on the size and relationships in the data model, but nothing comes to my mind currently.
Also, I would recommend checking "disable showing zeroes" on Data handling.
I hope this might can be the solution you're seeking for.
Regards.