Add Time Tracking in Sprint Pivot Report

[Albert Alemany]

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_ · Accepted solution]

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. 

[Dmitry Astapkovich _Colined_]

For some reason I have issues posting links to JQL reference here. So, here's a separate message with yet another attempt:

• worklogDate
• startofWeek
• slices in PIvot Report 
  
  

[Albert Alemany]

Hey Dmitry,

This is exactly what we need!

Thanks a lot for the quick answer.