1 Reply Latest reply on Jan 14, 2019 1:41 PM by Kevin Warren

    LOD IF Statement Help - Gauges

    Kevin Warren

      Hello,

       

      I am attempting to make a stacked bar chart with gauges but cannot get my LOD calculation to work. How can I combine lines 1&2 with 3&4 in the same calc?

       

      IF  [Bottom of Gauge] = 0 AND ATTR([App User]) = 'Yes' THEN 'Blue'

      ELSEIF [Bottom of Gauge] = 0 AND ATTR([App User]) = 'No' THEN 'Red'

      ELSEIF [Top of Gauge] = 1 AND ATTR([App User]) = 'Yes' THEN 'Light Blue'

      ELSEIF [Top of Gauge] = 1 AND ATTR([App User]) = 'No' THEN 'Light Red'

      END