I would like to create a calculated measure that returns the issues doesn’t contain the label regex test1 and test2 and Status should not be Closed. I tried the following measure but I am getting a 60-sec query timeout exception when I drill through issue . Is there any better way to do it without getting a timeout exception??
[Label].CurrentMember.Name NOT MATCHES ‘.test1 .’ AND
[Label].CurrentMember.Name NOT MATCHES ‘.test2.’
[Label].CurrentMember.Name MATCHES ‘.test1 |test12.’
Please help me out!! Thanks in Advance
We discussed this question within a support ticket. There is a short summary.
Then, after data import, where you import this new custom field as a dimension, you would get all those values AA, BB, CC as dimension members you could use for filtering reports. You can use this filter together with other dimensions in Pages, also with default Labels for additional filter options.
You may want to check out other community threads about counting issues based on labels informations, for instance, this one: Getting a count of a specific issue type that has a combination of labels
Ilze / email@example.com