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 collout gauge value as a percentage of total utilization?

 

 

 

 

 

 

 

 

Need Help

5 Replies

  • 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