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