Count of Tickets having value in Custom Field

Questions & Answers
1

Hi Team,

I have a custom field ‘External Id’. This field may or may not contain value for a Jira ticket. It is a text type field.
The field is imported as property.

I want to create a table where I get the count of tickets where this field has value (first column) and also where the field does not have value (second column).

I am using the below and getting an error (There was error when performing your request. Please retry or go to other page.) when trying to save the calculated member.

NonZero(
Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
IsEmpty([Measures].[Issue External ID] AND
–measure to add context of the report
[Measures].[Issues created] > 0 )
)
)
)

2

Hi @ajinder_singh ,
Use below code :

NonZero(
Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
IsEmpty([Measures].[Issue External ID]) AND
[Measures].[Issues created] > 0
)
)
)

Thanks,
Chhaya

1 Like
3

@ajinder_singh

A much faster calculation here would be using tuples.

But first, you could change the import configuration to enable dimension import and data type (from “text” to “string”) to import “External ID” as a separate dimension.

When data is imported, use this formula for empty External ID issues:

(
[External ID].[(none)],
[Measures].[Issues created]
)

And this one for non-empty External ID issues:

(
[External ID].DefaultMember,
[Measures].[Issues created]
)
-
(
[External ID].[(none)],
[Measures].[Issues created]
)

These would calculate the same results much faster.

Martins / eazyBI support

4

But if you stick with Descendants, this would be a better code for you:

Sum(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
IsEmpty([Measures].[Issue External ID])
),
[Measures].[Issues created]
)

Martins / eazyBI

1 Like