Gauge Chart

[#1]

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

[mgranillo]

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

[#3]

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).

[mgranillo · Accepted solution]

try

count({<Status={'A'}>}Operation)/

count(Operation)

[#5]

Thanks! It worked