Forum Discussion

kartibok's avatar
kartibok
New Member
9 years ago
Solved

Guage Help

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's avatar
    Anonymous
    9 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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