Average Task Size in a Sprint

Questions & Answers
, ,
1

Hello,

I am struggling to create a report that would calculate the average task size per sprint based on original estimates. Remaining estimates would not work in this case as carryover from previous sprints usually have low remaining estimates and would significantly skew this data. The objective here is to monitor task granularity.

Any help with creating this custom measure would be very much appreciated. Thanks!

2

Hi @Katya ,
Have you checked this Sprint Time Tracking balance report from the eazyBI demo account? Sprint Time Tracking (Remaining Estimate) balance - Issues - Jira Demo - eazyBI
The report is built based on Remaining estimated hours which resembles the original estimation at the beginning and changes over time when logging hours or estimates are updated.

If you need to get an average measure per task you can use measure “Sprint Remaining Estimates committed” from that report and divide it by sprint issue scope measure “Sprint issues committed”:

CASE WHEN 
  [Measures].[Sprint issues committed] > 0
THEN
  CoalesceEmpty([Measures].[Sprint Remaining Estimates committed],0)/
  [Measures].[Sprint issues committed]
END

best,
Gerda // support@eazyBI.com