Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data from multiple sources (mainly SQL queries).
In my model I built a table with a customer name and number of instances per customer.
I would like to build a button that will filter for the user only the customers who have under-X shows.
Actually it Sounds very simple and somehow I could not actually do it.
Can anyone help?
Thanks in advance
Create a variable like vShow and set 1 add this condition
if(vShow=1,sum({<Count={">10"}>}count), sum(Count))
Hi Amir
As we have not seen your data you have to be a more specific. That will help us help you better. I couldn't understand "Under x " shows part. Can you please elaborate a sample data would be a plus.
cheers
Hi,
This is example for the data
i want the names of all costumers under 10 times
John | 1000 |
Dan | 500 |
Alex | 400 |
Emma | 50 |
James | 10 |
David | 5 |
Jason | 2 |
Chris | 2 |
Walter | 1 |
Tayler | 1 |
Why do you need a button then ? Or you want to restrict the app to customer with count less than10 when you click that button ?
in the list box use
if(cust_count<10,customer)
Create a variable like vShow and set 1 add this condition
if(vShow=1,sum({<Count={">10"}>}count), sum(Count))