the pain that is EazyBI and showing accurate approvers

[Michelle Sharp]

Can anyone help? Very new to EazyBI.  I have a report set to show specific approvers as part of the workflow transition.  On the ticket, I can see the approvers for the specific transitions, but on the report using these same custom fields and transitions, it shows ALL the approvers for all the transitions. I can't get it to show the specific set of 3 approvers.  Any ideas

Many Thanks

[Daina Tupule eazyBI · Accepted solution]

Hello @Michelle Sharp 

You are correct. Dimension Approvers does not work with historical data representing an actor who made a specific status change. 

I would suggest using a dimension Transition Author instead for this purpose. You can use dimension Transition Author with the measure Transitions to status or Transitions from status. You can use Transition when specific status change from status => to status is needed. Or Transition status dimension.

Here is a report example in our demo account with dimensions Transition Author and Assignee. In this case, is shows that sometimes a different user changes the status than the Assignee:
https://eazybi.com/accounts/1000/cubes/Issues/reports/97457-issue-status-changes-by-users

Daina / support@eazybi.com 

[Paul Benati]

Daina,

How can I filter the Transition Author dimension to only those authors from my company?  Thanks.

[Daina Tupule eazyBI]

Hello @Paul Benati 

eazyBI, by default, does not have any indications in user dimensions (Transition Author dimension) of the user department/company.

I would suggest considering importing additional property with custom data import to mark (add some grouping for users) and build the new hierarchy you can use in your reports to select the needed group.

Here in the eazyBI community portal, we have a detailed step-by-step guide for this. The example is based on the Assignee dimension, but the same principles will work for the Transition Author dimension as well
https://community.eazybi.com/t/import-properties-for-jira-assignees-and-build-custom-hierarchy/8624


Best,
Daina / support@eazybi.com