Forum Discussion

kartibok's avatar
kartibok
New Member
9 years ago
Solved

Guage Chart

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

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    kartibok

     

    You can add a measure like: 

     

    Total incidents = CALCULATE(COUNTA(Table[incidents]))

    Then put this measure into Maximum value field. 

     

    Regards

     

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    kartibok

     

    You can add a measure like: 

     

    Total incidents = CALCULATE(COUNTA(Table[incidents]))

    Then put this measure into Maximum value field. 

     

    Regards