1 Reply Latest reply: Sep 3, 2014 11:30 AM by Andy Weir RSS

    Dynamic Target setting in Gauges

    Andy Weir

      I want to set dynamic targets to a gauge chart.

       

      I have the target data stored in a table for multiple KPIs

       

      LOAD

                Program Id,

                KPI,

                YYYYMM,

                Target

       

      In my expression I want to retrieve a Target for a specific KPI.  e.g.

       

      IF(KPI='MeasureA', SUM(Target),0)  If I add KPI as a filter and select MeasureA it returns the value I'm looking for. 

      I want to hard code the selection of the measure in this case and store as a master item for use in other charts and display multiple KPIs on the same page.