Report Table for Timespent

Questions & Answers
2

Hi @pyrocar

Here you can use the “Transition Author” dimension in rows and expand to the user level.
Then you could create new calculated measures for your column.

(
  [Measures].[Transitions to status issues count],
  [Transition Status].[Ready for Test]
)

Nonzero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
  [Measures].[Transitions to status],
  [Transition Status].[Ready for Test]
)>0
),
(
  [Measures].[Original estimated hours],
  [Transition Author].DefaultMember,
  [Time].Currenthierarchy.DefaultMember
)

)
)

  1. Total logged hours for these issues by developer
Nonzero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
  [Measures].[Transitions to status],
  [Transition Status].[Ready for Test]
)>0
),
(
  [Measures].[Hours spent],
  [Logged By].[User].Getmemberbykey(
    [Transition Author].Currentmember.key
    ),
  [Transition Author].DefaultMember,
  [Time].Currenthierarchy.DefaultMember
)
)
)

(
  [Measures].[Transitions to status issues count],
  [Transition].[Ready for Test => Develop]
)
  1. Here it would be important to see how do you link bugs exactly (which direction inward/outward and what link types do you use)?
    Anyways, please find how to import linked issues in eazyBI.
    Import issue links - eazyBI for Jira
    And here is a good use case to sum hours from linked issues (once imported)
    Summing Total Hours Spent on Linked Issues by Issue Type

Martins / eazyBI support