How to count labels that are empty too?

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

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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)]
})

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.