All eazyBI for Jira eazyBI for Confluence Private eazyBI

Estimated and logged hours in version
eazyBI for Jira

On this page:

Overview

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 spent"Suggested 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 Rows. To 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 the 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 the toolbox option Stacked to show a composition of measures by version. To 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