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

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

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

Hi,

 

i'm trying to create the measure, but it says that the table that i selected cannot be determined. Why is it?