Forum Discussion

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
7 years ago
Solved

Help with Gauge Percentages

Hi,   Could someone please point me in the right direction on this. I have selected 3 distinct values whish are Total Utilization, Approved budget and anticipated final. How can I calculate the col...
Need Help
AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Zaky

 

What is the "collout gauge value"? Can you explain a bit more what you need?

 

Zaky's avatar
Zaky
Icon for Helper IV rankHelper IV
7 years ago

Hi,

 

Sorry, it's  callout value in correct. I actually want the gauge to show percentage of Total budget utilization vs approved budget because beside the gauge visual has Card visual to show the budget spending in unit value.

 

 

Hope this will get you to my point.

 

Thanks

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Zaky

     

    Ok, how about creating a new measure based on the two you already have:

     

     

    PercMeasure= DIVIDE([Total utilisation YTD], [Approved Budget])

     

    and set it in values of the gauge. Then set the max of the gauge to 1 and min to 0