Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to make a gauge chart. I have a table with some data of operations. Then there is a column that can be "approved" or "not approved". I want to make a gauge chart of % of approved operations, but I can't find a way to do it.
Thanks
Ivan,
You should be able to simply add your calculation under measures. something like count({<approval={'approved'}>}operations)/count(operations)
Can you provide a specific example?
Mike
Certainly
The table, named ACUM, is like this:
Operation | Description | Status |
---|---|---|
1 | Buy | A |
2 | Buy | O |
3 | Sell | A |
I want to make a gauge with % of As (eventually, I would like to also filter them by Buy/Sell).
try
count({<Status={'A'}>}Operation)/
count(Operation)
Thanks! It worked