This content has been marked as final.
Show 1 reply
-
1. Re: Colour by pie chart KPI
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
-
exampleworkbook ed mc.twbx 19.3 KB
-