2 Replies Latest reply on May 8, 2017 10:54 PM by Lance Martens

    I would appreciate any assistance with how to include “Traffic Light” shapes in a Table

    Lance Martens

      Hi All,

       

      I would appreciate any assistance with how to include “Traffic Light” shapes in a Table

       

      Logic:

      • I have three performance measures: Tonnes Actual, Tonnes Target and Tonnes Variation

       

      Required:

      • I’m trying to get the variation traffic lights to be part of the Tonnes Table (below variation, Green arrow Up = positive, and Red arrow down = negative variation)
      • I’m also having difficulty getting a “Green” and “Red” state to appear, all I get is Red?
      • At present I can only create two separate worksheets and then orientate them in a dashboard to get the result I need (see proof of concept image?)

       

      Proof of concept.JPG

       

       

      I have attached my workbook (v10.2)

      Any guidance will be most appreciated, 
      Cheers,