LOD is probably an overkill here. IsOpen calc (if "open" then 1 else 0) and put SUM([IsOpen]) on color.
Thanks for your suggestion. However, If you read the requirement user wants this.
If you see the data then Cat1 has maximum number of open issues (3) that's why its dark geen,
Cat2 has only one open issue so light green and Cat3 has no any open issues so its lighter green.
Correct me if I'm wrong. I don't think I've over used LOD here. There might be some more easiest way to achieve this. If you've any simpler solution then please share. It'll be a good learning for me.
Thanks Mahfooj Khan, exactly what i wanted to do. I was missing the category on detail shelf.
I appreciate it.
I thought that this is the most important part:
So that the user can know which category has the most open issues and go to fix them.
With that I don't see why to count the other states unless we'd want to introduce some sort of ranking or additional rules (i.e. 3 "in progress" cases need more attention than 1 opened).
Also, since pie chart is already at category level - it doesn't not need a LOD calc but I see the temptation to use it.