I am trying to create a Pie Chart which should give me two sections-Blocked and Not Blocked based on the following two conditions
Condition 1:
If([Lifecycle1]>0,'Blocked','Not Blocked')
Condition 2:
If([Lifecycle2]>0,'Blocked','Not Blocked')
Here is what I am doing to get this done. I have created a Dimension with the following expression inside it.
=if([Lifecycle1]>0
OR
[Lifecycle2]>0,'Blocked','Not Blocked')
And in the Expressions, I am using
Count(Distinct([Application ID]))
The pie chart gives me two sections with Blocked and Not Blocked. When I select the Not Blocked, the whole pie changes to Not Blocked, which is fine. But when I select Blocked section of the pie, it returns both Blocked and Not Blocked. What is the issue
