Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to count labels that are empty too?

petemo94 August 8, 2019

In EazyBI, I'm trying to also count the # of empty labels (as well as other labels).  Here's what i have as a calculated member. 

My issue is that i want to count those issues with an empty label too.  Any idea how?

 

Aggregate({
[Label].[design],
[Label].[pm-reviewed],
[Label].[arch-reviewed],
[Label].[Workflows],

[label].[HOW TO COUNT EMPTY LABELS?]

})

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 8, 2019

You can't count something that is not there in this way.  It doesn't have a way to do "lable is empty" like Jira does.

petemo94 August 9, 2019

A local expert fixed this for me.  The correct syntax is shown below. Worked great for me!

 

Aggregate({
[Label].[design],
[Label].[pm-reviewed],
[Label].[arch-reviewed],
[Label].[Workflows],
[Label].[(none)]
})

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events