Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be try to enter 0.5 here for Segment 1 and 1 for segment 2
Hi Sunny,
Thanks for reply !
Keep the color non-calculated... green() for segment 1 and Lightred() for segment 2
The percentage can be negative as well? May be do -1 for min... I am not sure...