How to filter out issues with empty fields

Questions & Answers
1

Hi
I’m rather new with eazyBI, and I’ve one challlenge: how to filter out issues that have empty fields.
In Jira this is straight forward in a filter: “… IS EMPTY” or IS NOT.

But how do I do this in eazyBi?
Do I have to set up an calculated field?

br
bjorn

2

Hi ursus,
Welcome to the eazyBI community!

There are different ways to achieve this:

  • Most dimensions have member (none), that represents that dimension value is empty for the issue. So you can filter in pages value (none) and get all issues where this field is empty.

  • For dates and property fields you can create a row filter in the table that Not matches “.” (matches “.” would be equivalent to IS NOT EMPTY)

  • In calculations, you can use IsEmpty() function: IsEmpty

I hope this helps.

Kindly,
Ilze

3

Thx for reply.

I’ve tried this, but as a result I get all issues, with start date and also without start date.
What do I do wrong?

Sum(
Filter(
[Issue].[Issue].Members,
IsEmpty([Issue].CurrentHierarchyMember.Get(‘Start Date’)) OR
[Issue].CurrentHierarchyMember.Get(‘Start Date’) = “”
),
[Measures].[Issues created]
)