Add Time Tracking in Sprint Pivot Report

Albert Alemany_o38sgm

Hello,

 

Our team is currently doing weekly sprints, and we're using the Pivot Reports to keep track of the tasks done, performance, etc.

 

The two main metrics we look at in the Pivot Reports are Time Spent and Story Points, to see. What we noticed however, is that the Time Spent always captures the entire task but it doesn't limit it to the selected Sprint.

 

Is there any way of seeing the Time Spent only during the period being analyzed?

 

Thanks!

Dmitry Astapkovich _Colined_

Hello @Albert Alemany ,

There will be two parts of the answer

1.  In order to see only the time logged within the period, you need to switch / add Worklogs tab. Here's a demo report for you:



2. If you need to select issues that had time logs during the last week, you can use the following JQL: 

worklogDate >= startOfWeek(-1w) AND worklogDate < startOfWeek()

This piece could be used either as a part of your source search query and/or JQL for slices.

Please let me know if this answers your question.