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



                Program Id,





      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.