2 Replies Latest reply on Sep 13, 2013 9:44 AM by Kerith Gaines

    Traffic Light Calculated Field - Middle Range?

    Kerith Gaines

      Hi Guys,


      I'm striking out here trying to get my traffic light set up for a dashboard. I figured I need to use a calculated field and then dump it on to the color shelf (and change shape to circle) but I'm stuck on the correct expression to use operators to show greater than x AND less than x (needs to meet both of those criteria to be 'yellow')


      This is what i have:


      IF [Avg Days Delayed]<31 THEN 'Green'

      ELSEIF [Avg Days Delayed]>60 THEN 'Red'

      ELSEIF [Avg Days Delayed]>30 AND <=60 THEN 'Yellow'



      Tableau is not liking ELSEIF [Avg Days Delayed]>30 AND <=60 THEN 'Yellow'


      How should I be writing that?


      Thanks in advance!