Current Assignee without assignee history

Questions & Answers
1

Hi eazyBI Community :waving_hand:

I’m building a report where assignees are in rows and measures in columns include:

  • Hours spent

  • Number of issues “ completed “ at the end of the sprint and not completed at the end of the sprint

I also filter by Sprint.

i want the

The problem:
By default, eazyBI only shows the current assignee, not the assignee who actually worked on the issue during the sprint.
For example, if an issue was assigned to Alice in Sprint 10 but later reassigned to Bob, filtering by Sprint 10 will incorrectly show the metrics under Bob.

i wanted to know what kind of solution there is for this problem..i tried using issue history but its not a dimension

thanks

2

Hi @noa1483

Please check the documentation page about the sprint scope measures in eazyBI:

Those would calcualte tickets for the historical assignee of the ticket when the event happens (sprint completed, not completed etc).

For “Hours spent” calculation, you could try this formula when creating new user-defined measure:

(
[Logged by].[User].getmemberbykey(
[Assignee].currenthierarchymember.key
),
[Measures].[Hours spent],
[Assignee].Currenthierarchy.DefaultMember
)

It would look at historical user who logged the hours in the issue for the particular sprint if the user is the same as displayed assignee in report rows.

Martins / eazyBI