I am trying to create chart with following query, i need exclude the issues which is having label2
project = “Project1” AND (labels = FWQA_TestDev AND labels != FWQA_Triage)
I tried with following calculated member without luck
[Label].CurrentMember.Name MATCHES ‘FWQA_TestDev’
[Label].CurrentMember.Name NOT MATCHES ‘FWQA_Triage’
any help on this? or any reference document on how to do it?
I’d like to know the answer. please help.
Hi @prasad and @enguyen,
The idea to use aggregate is correct. But in this case, to get the count of issues with specified labels you should aggregate issues instead of labels and for each issue validate assigned labels. For aggregation, you may use function Count() and iterate through issues using function Descendants()
--iterate through issues
--which have label FWQA_TestDev
[Label].[FWQA_TestDev]) > 0
--and don't have lable FWQA_Triage
Zane / support@eazyBI.com
Thank you for helping. I tried to create a new calculated member and copied your suggestion for the contents but keeps getting error message "“Query execution timeout of 150 seconds reached. Please try to make query simpler”.
Do you have other suggestion how to get around this?