Check for invalid assignees

Hi all,

Assignees for our tickets can be deactivated (due to maternal leave, leaving the company etc). For a sanity check, we have made an eazyBI piechart with Unassigned Issues or Missing Due Date. We’d like to add also the category Invalid Assignee (=assignee is deactivated).

Do you know if it’s possible to filter the issues with Invalid Assignees and add it to the piechart? If yes, how would you do that?

Thank you in advance!


Such filtering is possible by adding a new property to the Assignee dimension with additional data import. However, the standard data model currently does not have the property of the active or inactive status of the user.

For that, you need the data source giving the columns of user key and status. Perhaps, the SQL query from the Jira database is the most appropriate:

SELECT user_name,active from cwd_user;

With such a query, you can create a new data source and map the data to the Issues cube:

After the data import, you can create a new hierarchy in the Assignee dimension to group the active and inactive users:

Janis, eazyBI support