Estimated and logged hours in version

On this page:


This report shows how many hours have been estimated and spent by version. Additionally, it shows how many hours are remaining per each version. In case hours have been logged more than originally estimated, the report shows remaining overestimated hours as well. 

How to build it

To build this report start with table view and in the Measures dimension select measures Original estimated hours, Hours spent, Remaining hours and Remaining overestimated hours, don't forget to unselect default Issue created measure that we won't need in this report example.

  • Original estimated hours - a total of original estimated hours. On the Time dimension grouped by issue creation dates.
  • Hours spent - a total of hours spent on issues matching the selected dimension members. 
  • Remaining hours - calculates how many hours are left to reach Original estimated hours when logged time is less than planned. Based on Original estimated hours and Hours spentSuggested use case - without Time dimension. The measure might not work correctly with Time dimension.
  • Remaining overestimated hours - calculates how many hours will go over Original estimated hours when logged time and remaining estimated time is over planned. Based on Original estimated hours, Remaining estimated hours, and Hours spent. Suggested use case - without Time dimension. Measure might not work correctly with Time dimension.

In the report Rows, select the Fix version dimension and select Version level from Status hierarchy. Select Nonempty option for RowsTo eliminate fix versions that don't have any value for the measures, select Hide empty rows and columns.

Add the same Fix version dimension to Pages and select Unreleased versions to filter report data only for versions that haven't been released.

In Pages select also dimensions Project, Priority, Issue type, Assignee for filtering the report. 

To show report data only for versions that have estimated time, filter table by Original estimated hours measure (> 0). With drag and drop option check that your table has measures in this order: Hours spent, Remaining hours, Remaining overestimated hours and Original estimated hours as measures in the chart are displayed in the same order as in the table.

Then switch to the Bar tab and select in toolbox option Stacked to show a composition of measures by version. For measure Original estimated hours change the chart type to scatter and add a data label to it. Change colors for measures to better represent the nature of those measures. 

See also