Report not showing issue from completed sprint

Questions & Answers
1

We have some tasks in jira that was planned for a previous sprint. The sprint was then closed and the task automatically moved to next sprint, without the task being finished. In the sprint field for these task it is marked as "Completed sprints: " and then the sprint it was moved to (see VME-201 task below).

In eazyBi we then have a report that shows remaining estimate for tasks over sprints, but all tasks that was automatically moved when a sprint was closed, does not appear in the eazyBI report.

An example of an issue that was in a sprint and then automatically moved to another sprint

image
image.png879×905 51.3 KB

The eazyBI report that should show remaining estimate hours for all task in the project, but there is no hours in the sprint “2019 W09+10”.

image
image.png1122×754 38 KB

Can you help me how to get the hours to appear in the report.

2

Hi,

Please try creating a new calculated measure using the following code:

( 
[Measures].[Remaining estimated hours history],
[Transition Field].[Sprint status],
[Sprint Status].[Closed],
[Issue Sprint Status Change].[Active => Closed]
)

Martins / eazyBI support

3

Hi Martin

It does not work

Here is my sprint in jira (5 tasks)

image
image.png874×494 33.6 KB

My report where “Remaining estimate incl completed” is your code

image
image.png838×388 20.8 KB

The definition of “Remaining estimate incl completed”
image

Are there any other info you need to help with this ?

4

Hi,

Perhaps, I misunderstood the requirement then.
Please check these two sample reports with custom time tracking calculations.

https://eazybi.com/accounts/1000/cubes/Issues/reports/93784-sprint-remaining-estimates-tracking

https://eazybi.com/accounts/1000/cubes/Issues/reports/144076-time-tracking-burndown-in-selected-sprint

I think you should be able to find the right calculated measure code for you.

Martins / eazyBI support