Gauge Chart Issue

vanderson009 — Tue, 23 Dec 2014 13:12:35 GMT

Hi guys,

I have to create Actual Vs Budget by using Gauge Chart.

Can anybody tell me how to create this by using gauge chart.

-- Thanks and Regards,

Villyee

Re: Gauge Chart Issue

Peter_Cammaert — Tue, 23 Dec 2014 13:18:05 GMT

Create a Gauge chart (e.g. a Dial) without dimensions and with a single expression like:

= sum(Actual) / sum(Budget)

=(sum(Actual) - sum(Budget)) / sum(Budget)

Set the number format to percentage, and the scale from 0 to 1 (or higher if you use the first expression.

Then go and experiment with the various settings.

Peter