3 Replies Latest reply: Sep 8, 2017 5:03 AM by Francisco Cohen RSS

    Trafic light dashboard

    Francisco Cohen

      Hi,

       

      I want to create a dashboard in a semaphore/trafic light style.

      My source data is:

       

      ProjectStatus
      Project 1-1
      Project 20
      Project 31

       

      Note: -1 is Red, 0 Yellow and 1 is Green

       

      My script:

       

      LOAD

           "Project Code",

           "Status"

      FROM [lib://Projects/projects.xlsx]

      (ooxml, embedded labels, header is 2 lines, table is Milestones);

       

      I want to build a dashboard, which would represent my status values in a trafic light, such like this:

      Untitled.png

       

      Thank you,

      FC.