I am trying to create a report using the logged by dimension but I believe that my report is not working because the custom fields I need on my report are associated to the issue fields.
My goal is to show how many hours are logged by a user in a given month, then the total number of C1 - CF and C1 - NCF found by user in that month.
Also, is C1 - CF created based on the reporter who created the issue? Is C1 - CF resolved also based on the report, or the person who triggered the transition to resolved?
Hi @Sdemidow
The Logged by dimension works only with the Hours spent measure, if you wish to show any other measures split by users in this report, you can create a new measure that will take the Logged by user and switch to an Assignee dimension to get the data.
For example, instead of “C1 - CF created”, create a new measure with the following formula:
(
[Measures].[C1 - CF created],
[Assignee].[User].GetMemberByKey(
[Logged by].CurrentHierarchyMember.Key
),
[Logged by].CurrentHierarchy.DefaultMember
)
Best regards,
Nauris