2 Replies Latest reply: Feb 27, 2015 10:25 AM by Andrew Whitfield RSS

    Expressions Defenition Gauge Chart

    Marius August Larsen

      Hi,

       

      I've made a gauge chart that shows how much % electricity that is saved (oldest selected year vs latest selected year), but the color will not change as the percentage change.

      Gauge.PNG


      Text in Chart: =num(sum({<År={"$(=max(År))"}>}kWh)/sum({<År={"$(=min(År))"}>}kWh)-1,'#.0%')


       

      I need help with the definition of the expression (see picture)

      definisjon.PNG

       

       

      __________________________________________________________________________________________

       

      some more screenshots:

      Presentation.PNG

       

      Segment 1:

      Segment1.PNG