6 Replies Latest reply on Sep 18, 2018 7:39 AM by jeremy.yatco

    Visualizing Traffic Light Indicators for Different Measures/Parameters (# / $ / %)

    jeremy.yatco

      Hello,

       

      I am trying to create a dashboard capturing different Events in a single report. The status of the event should be displayed in stoplight feature (G/Y/R) in a column reflecting if it has hit or breached target/triggers.

       

      Each event has different targets that can be classified as "Green," "Yellow," or "Red."

       

      I.e.

       

      Event 1 (#)

       

      Event 2 ($)

       

      Event 3 (%)

       

      Event 4 (color)

       

      I have attached the workbook for more context - any help is greatly appreciated in creating a formula that reflects the green, yellow or red status accurately.