For JSON imported bug data, count number of missing entries

Questions & Answers
,
1

Hi,
we are using JSON imported bug data and parsing Reporter and Assignee fields.

In some entries, bugs do not have assignee and hence JSON output does not contain this field.

We have created Dimension for Reproter and Assignee.

We can count particular reporter “jack” as:

Aggregate({
Filter(
[Bug Reporter].Members,
[Bug Reporter].CurrenthierarchyMember.Name MATCHES (".jack.")
)
})

We can count particular assignee “jack” as:

Aggregate({
Filter(
[Bug AssignedTo].Members,
[Bug AssignedTo].CurrenthierarchyMember.Name MATCHES (".jack.")
)
})

How can we count number of missing entries of Assignee? For example here, Bug is created by Jack, but Bug is not assigned to anyone. In parsing Assignee, we do not get entry as “(none)”.

Thanks,
Vrukesh

2

eazyBI does not add a member (none) for custom data cubes by default. However, this member might be needed to see unassigned entries. I would suggest modifying the import options and setting the (none) value for entries with no assignee.

If you are using REST API data import, you can add a custom JavaScript code to modify imported data. For example, like this

doc.field_name = doc.field_name ? doc.field_name : "(none)"

Please use your column name instead of field_name.

Daina / support@eazybi.com

3

Hi Daina,

This solution works! :slight_smile:

Thanks,
Vrukesh