1 2 Previous Next 17 Replies Latest reply on Jun 15, 2017 5:16 PM by Sandhiya Ramane

    How do I use more than one column to be displayed as a shape in a single worksheet

    Sandhiya Ramane

      Newbie here - I have been trying to create a worksheet which depicts  score of a student based (using traffic light concept) on the final grades.

      If a student is assigned to 0,1,2, then red,yellow and green should be populated to the subject column respectively.


      Attached below is the expected output -



      But I am having issues in creating one than one measure to be used in the color field and have it displayed as a separate column, if I do it for Math- I am unable to do it for Science and Eng. I tried creating separate KPIs but wouldn't work.

      Any help is appreciated.


      Thanks in advance!


      Here is a screenshot of sample Input data :

        1 2 Previous Next