Gauge chart fill to value % segments setup

[Anonymous]

Hi,

I need some help with my gauge chart.

it wont fill to value with green (-%) or red (+%)

Expression:

=if(sum({<År={"$(=max(År))"}>}kWh)/sum({<År={"$(=min(År))"}>}kWh)>=0.05, Green(), LightRed())

Gauge settings Min and max value, lower bound. What to input?

[sunny_talwar]

May be try to enter 0.5 here for Segment 1 and 1 for segment 2

[Anonymous]

Hi Sunny,

Thanks for reply !

[sunny_talwar]

Keep the color non-calculated... green() for segment 1 and Lightred() for segment 2

[Anonymous]

[sunny_talwar]

The percentage can be negative as well? May be do -1 for min... I am not sure...