5 Replies Latest reply on Jan 8, 2019 1:26 PM by SOU SOU Phomsavanh

    Conditional Bar Color Based On Varying Time

    SOU SOU Phomsavanh

      Howdy

       

      Can someone tell me what I am doing wrong, I want the bars to change color based on a deadline. Now the deadline varies nightly so it isn't a fixed time. I created the following calculation (OFRA Time Exceedance) but it doesn't appear to work. Any help would be appreciated. Please refer to the OFRA (4) tab

       

       

       

       

      IF DATETIME([Ofra])>DATETIME([OFRA Deadline])

      THEN "Orange"

       

       

      ELSEIF DATETIME([Ofra])<DATETIME([OFRA Deadline])

      THEN "Blue"

       

       

      END