Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to display two points on a gauge without a formula? I have a Year to Date Actual Sales figure and a Year to Date Budget figure and I want the needle to display the actual sales point and the budget number end point (most right point).
Additionally, If there is a way to easily show the percent of Actual to budget on the gauge, that would work as well.
Thanx
I don't know what you mean with "without fomulas" but this is how it works.
For making a simple gauge you need (at least) 2 values. 1 is the needle the other is background.
You set your needle as an expression
You set your background in the presentation tab at the min/max gauge setting.
For example: Expression = Sum(sales)
Max Gauge (Budget*2)
If you have 2 segments your budget will be in the middle of the gauge.
I hope this helps