Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to be able to filter on a calculated value (like the monthly revenue for example).
I have all sort of charts and I would like to see appearing only the customers Which monthly income is superior to a certain value.
Customer | Monthly income |
---|---|
Customer 1 | 10000€ |
Customer 2 | 20000€ |
Customer 3 | 500€ |
I would like to be able to select only customer 1 and 2 (revenue above 1000€)
This sound basic but I'm stuck
Hi Martin,
select "straight table chart"
take the "customer" field in dimensions
expression:-if(Amount>1000,Amount)
i hope it will work
You can use dimension limits to restrict the customers.