5 Replies Latest reply: May 11, 2017 4:22 AM by Sunny Talwar RSS

    Gauge chart fill to value % segments setup

    Marius August Larsen

      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?