Report Table for Timespent

Questions & Answers
1

Hi all.
I’m newbie of eazyBI so my question may seem stupid.

I need a report table like this:

Screenshot_12
Screenshot_122834×297 10.1 KB

This report must show info for selected period:

  1. Developer
  2. Count issues transitioned by this developer to “Ready for Test” status
  3. Total estimations for this issues
  4. Total spended time for this issues by developer
  5. Count returned to “Develop” status from “Ready for Test” status (aka reopened)
  6. Total spended time for all linked bug to this issues (summ of all users who works on this bugs)

Is it possible? I’m just starting to watch learning videos, maybe someone already solved a problem like my problem? Thanks

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