Get "Logged By" time from user who tracked the most time

Questions & Answers
1

I am looking to build a report where the user who logged the most time on an issue is listed as a row in the report.

For example, two developers track time on the same issue, one who does development, and one who does review. The assignee is usually left as the reviewer so I cannot use the issue assignee. Is there a way to calculate a measure for the person who spent the most time tracked on the issue?

2

Hi @Sdemidow

Thank you for the question!

You may create a calculated measure that looks for the users who have the maximum logged hours and displays their name:

(
  Filter(
    [Logged by].[User].Members,
    (
      [Measures].[Hours spent],
      [Logged by].CurrentHierarchyMember
    ) = 
    Max(
      [Logged by].[User].Members,
      (
        [Measures].[Hours spent],
        [Logged by].CurrentHierarchyMember
      )
    )
  ).Item(0).Name
)

In the report, it would look like this (Hours spent split by logged by users is added to show how the formula works):

image
image1886×852 137 KB

Best,
Ilze, support@eazybi.com

3

This worked perfectly, thank you so much!