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

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




      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."




      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.