Guage Help

[kartibok]

Hi,

I have a spreadsheet where I have, say 30k rows which are incidents. Approximately 10k of these are marked as closed.

I would like to automate the gauge chart. So far I have it as 0 on the left, 10k shaded (which is picked up in the Fielda > Page Level Filters where my service type contains "closed" and I have to add the total in the Format Gauge Axis > Maximum (numerical entry)

I can't get my head round the Maximum value field.

Any comments are appreciated.

Regards

J

[Anonymous · Accepted solution]

Hi @kartibok,

For your scenario, you can refer to below steps to create guage visual.

0 to min value, all row count as max value, closed records count as the value.

Measure formulas:

current = COUNTROWS(FILTER(ALL(Table),Table[Staus]="Closed"))
max = COUNTROWS(ALL(Table)) 
min = 0

Regards,

Xiaoxin Sheng