Hi Team,
How to define calculated measure for hours spent by specific role of the users?
Let’s say, for example : Hours spent by QA, DEV and PM role
Jira Project roles are not available in Eazybi.
It will be great if you could help me in case of importing project roles to eazybi and calculate the hours spent by each role(QA, DEV and PM)
Regards,
Suchithra S
Hello,
It is possible to import project role based on assignee and reporter. For more details you can check below link.
Regards,
Nanda Hareesh.
Hi Nanda,
Thanks for the reply
Assignee field is not static, it is getting changed throughout the life cycle based on the status.
Not able to get the hours logged by Dev role, QA role by the use of “Assignee by project role” dimension because it will consider only the current assignee.
Is it possible to achieve my requirement by any other workaround?
Looking forward to hear from you
Thanks and Regards,
Suchithra S
Hi @Suchithra,
You can use the Assignee by project role and Assignee dimensions as a workaround. Define the following calculated measure to retrieve work logged from users of a particular project role:
CASE WHEN [Measures].[Issues created] > 0
THEN
([Logged by].[User].GetMemberByKey(
[Assignee].CurrentMember.Key
),
[Measures].[Hours spent],
[Assignee].CurrentHierarchy.DefaultMember,
[Assignee Project Role].CurrentHierarchy.DefaultMember)
END
The formula looks for Assignee dimension members that are part of the selected Assignee by project role member. From there, it retrieves the respective Logged by dimension member and returns the amount of work logged by this user, ignoring if the user is the assignee of those issues.
The report could look similar to the one below:
Best,
Roberts // support@eazybi.com
