Time Spent for resolved issue in sprint

Questions & Answers
1

Hi,
I want to create a report that shows me time spent for issues that resolved in current sprint.

Can Help me to resolve this?

Thank’s

1 Like
2

Hi,

In this case, you could try using the “Hours spent” measure and filter your report by “Resolution” dimension.
It should calculate the hours spent on issues that were resolved in the displayed/current sprint.

Martins / eazyBI support

1 Like
3

hello @martins.vanags ,
this way doesn’t it show all the hours registered in the issues, instead of only the hours spent in the sprint?
[Edit] I tried, it catches time registered outside the sprint as well.
regards.

4

@Mauro_Bennici it depends on the report.
Do you use “Sprint” dimension in the report?

Martins / eazyBI

5

Yep, what I’m trying to get * is:

  1. Avg Hours spent in resolved issues vs hours spent in not resolved issues per sprint
  2. Avg Hours spent vs cycle time per sprint

Both have sprints as a dimension

*the focus is on .2, I somehow went somewhere with .1 already

6

@Mauro_Bennici
Please share more details about the requirement nr.2

What defines the beginning of cycle and what defines the end of the cycle in your “cycle time” definition?
And how do you want to calculate the average (by sprint, by time etc)?
Have you tried using “Hours spent” measure with “Transition Status” dimension?

Martins / eazyBI

7

Hi @martins.vanags , thanks for the reply.
Cycle time for this instance = date diff ( last resolution, first assignment).
The average is by Sprint, yes I tried using hours spent but I get a bunch of non valid results…
I may be using the wrong definitions, what I’d like to get is the ratio between time logged for the activity and elapsed time during which the activity is getting worked on, I.e. I assign myself a task, keep it open a week before transitioning it to done but log 2 days on it, so the ratio is 2/5.

8

Hey @Mauro_Bennici

Please export your definition and attach it here or contact support@eazybi.com and send us more details about your current report.

Martins / eazyBI

9

measures.avg effort to elapsed ratio:

([Measures].[Average hours spent of resolved issues]/8)/([Measures].[average resolution workdays])

where:

average hours spent of resolved issues:

CASE WHEN [Measures].[Issues with Hours spent resolved] > 0
THEN
[Measures].[Hours spent resolved] /
[Measures].[Issues with Hours spent resolved]
END

the point is: 1. how can I roll it up to epic level?
and 2. Time spent in done issues in Epic

10

@Mauro_Bennici

We would need to see a report’s full definition (not just a formula for calculated measure) to understand why your formula won’t work correctly in report.
This formula seems correct and tis should work correclty on epic level when epics from “Issue” dimension.

If you don’t want to upload it here, contact support@eazybi.com

Martins / eazyBI

11

sorry @martins.vanags I need a further detail: should I use “issues” and filter by “issue type” on pages to sort epics out, or should I use the Epics hierarchy on issues?
When I use issues and filter by issue type “Epic” on pages, this formula:

[Issue].CurrentHierarchyMember.GetLinkedMember('commissioned by').get('Track Type')

works, and correctly gets me the “track type” attribute on the linked issue, but the measure I posted before (effort to elapsed ratio) won’t work.

If I use the Epic hierarchy on issues, the avg effort to elapsed ratio is correct, but the track type is blank.
there’s nothing else in the report, just issues and those two measures I wrote down.

[EDIT] I found in the documentation a solution for the second issue, I used:
[issue].currenthierarchymember.getlinkedmember(‘attribute’,[issue].[issue]) to get back to the level I need, BUT:

  1. for no apparent reason, some attributes I retrieved are blank, even if I can go to source and check and they’re there. May solved epic be treated differently?
  2. the “hours spent in resolved issues” working with epic level seems not to consider hours in the issues inside the epic.