Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am working with guage charts but some problem in my chart i cant get result to calculated expression
can you post your chart expression an also the Min and Max expression for your gauge?
Expression
=Num(Sum([# Departures Performed]) / Sum([# Departures
Scheduled]), '##.#%')
Min = 0.5
Max = 1.2
i can't get answer sir let me know please vinieme12
Hi,
Firstly you don't really need to do Num formatting in your expression, Select
"Number" Tab >> Select your expression on the left space >> Check Fixed >> number of Decimals and
Select Show in Percentage at the bottom.
when you hover over the gauge needle what value is shown ? and what is the expected value when you manually evaluate the percentage?
I would suggest to test the expression in Straight Table first, to see what are possible values for Min and Max values.
After that you can make a decision what values you want to use for Min and Max in Gauge chart.