1 Reply Latest reply on Dec 20, 2016 8:33 AM by Michel Caissie

    Colour by pie chart KPI

    Oliver Shingfield
    Oliver Shingfield Dec 20, 2016 2:37 AM

      Hi Guys,

       

      I have a box plot of Computer's (PC's) that have hardware and software on them. If any of the software or hardware is out of support I want the high level box for that PC to turn Red. So for example if you click on PC 3, there are 2 hardware products in support and 1 software product out of support. So the high level box for PC 3 needs to turn red. If for example both the hardware and software for that PC was in support (green) then I want the box for that PC to be Green.

      I have attached the packaged workbook, this is an example workbook and dataset that have been made to replicate my situation.

       

      Any help would be really appreciated,

       

      Kind Regards,

       

      Oli

        • 1. Re: Colour by pie chart KPI
          Michel Caissie
          Michel Caissie Dec 20, 2016 8:33 AM (in response to Oliver Shingfield)

          Oliver,

           

          check in the attached...

           

          For both Software and Hardware datasource I made a calculation  isRed  returning True if one Supported for a PC is  Red.

          {FIXED PC: MAX( if [Supported?] = 'Red' then 1 else 0 end  )} = 1

           

          In the PC datasource I made a calculation Color  returning  Red if both isRed are true.

          if ATTR([Hardware (Example Dataset)].[IsRed]) OR ATTR([Software (Example Dataset)].[IsRed]) then 'Red' else 'Green' end

           

          Michel