Gauge Chart Compare Years

[Anonymous]

Hi,

How can i create a gauge chart that shows how much % electricity that is saved (oldest selected year vs latest selected year)

Info:

In my table I have data for the consumption of electricity hourly. Dimensions name: kWh

[datanibbler]

Hi Marius,

you need the total consumption per year - then you can build some expression (possibly using set_analysis) to grab the value for the 1st and last year in the selected range and calculate the % difference between those.

How exactly is that done? Does the user select on two separate fields?

=> Once you have one single value, you can display it in a gauge chart.

HTH

Best regards,

DataNibbler

[Gysbert_Wassenaar]

num(1-sum({<Year={"$(=max(Year))"}>}kWh)/sum({<Year={"$(=min(Year))"}>}kWh),'#.0%')

[Anonymous]

Thanks!

Think that expression was correct, but the colors in the graph shows 50/50 green gray...