Compare Assignee with Logged By

Questions & Answers
1

I am trying to figure out how to display the count of issues that have hours Logged By the Assignee. Is there a way to make a query like this in EazyBI? Example below

This would not be included in the results

Assignee - Jane Doe
Logged By - Jeff Roe, John Doe

This would be included in the results

Assignee - Jane Doe
Logged By - Jane Doe, Jeff Roe
1 Like
2

Hi @thntf ,
If you want to see “Hours spent” logged by the user who is also the assignee for the issue, you can use this formula “Hours spent by user” from the demo report Logged hours by user on assigned and unassigned issues - Issues - Jira Demo - eazyBI

(
  [Measures].[Hours spent],
  [Logged by].[User].GetMemberByKey(
    [Assignee].CurrentMember.Key
  ),
  [Assignee].CurrentMember
)

Further, I am using this formula to create a new metric to count those issues using Sum(), Filter() and DescendantsSet() functions. It is adjusted, so it would ignore the time when the hours were logged, but links measure to time by issue creation date:

Sum(
  Filter(
    DescendantsSet(
      [Issue].CurrentHierarchyMember, [Issue].[Issue]
    ),
    -- filter issues where hours are logged by the assignee
    (
    [Measures].[Hours spent],
    [Logged by].[User].GetMemberByKey(
      [Assignee].CurrentMember.Key
    ),
    [Assignee].CurrentMember,
    --ignore when the hours were logged
    [Time].CurrentHierarchy.DefaultMember
    )>0
  ),
  --measure is linked to time by issue creation date
  [Measures].[Issues created]
)

best,
Gerda // support@eazybi.com