7 Replies Latest reply: Apr 6, 2017 3:30 PM by Sunny Talwar RSS

    How do I create a KPI pie-chart out of summarized data?

    Robert Lundsten

      Hello!

       

      I am trying to create a compliance KPI pie-chart out of summarized data.

      Here is the data (example):

      ComputerName,Update,Computer_Installed,Computer_Applicable

      PC01,MS09-001,0,1

      PC01,MS09-002,1,1

      PC01,MS09-003,1,1

      PC01,MS09-004,0,1

       

      Here is my attempt to create a dimension:

      if(SUM(Computer_Installed) / SUM(Computer_Applicable) <= 0.80, '0-79%',

      if(SUM(Computer_Installed) / SUM(Computer_Applicable) <= 0.90, '80-89%',

      if(SUM(Computer_Installed) / SUM(Computer_Applicable) <= 1, '90-100%')))

       

      I cannot use the above script. I get error...

       

      The measurement would be:

      COUNT(DISTINCT ComputerName)

       

      Can anyone help?

       

      Thanks!

       

      Robert