All eazyBI for Jira eazyBI for Confluence Private eazyBI

Time tracking measures
eazyBI for Jira

Available for eazyBI for Jira Cloud and since eazyBI version 6.6.

By default, eazyBI imports measures Hours spent and Original estimated hours as part of core measures. Those measures represent originally estimated time on issues and actually spent time on issues. While you can use those measures in many reports, they are hard to analyze side by side over time.

eazyBI allows importing additional measures to analyze spent time and originally estimated time by issue resolution and close dates. If you would like to extend time tracking measure analysis, we suggest enabling an import of the additional set of measures for time tracking. Go to import options, tab Additional options, and mark the option to import additional measures for Hours spent and Original estimated hours.

Measures

eazyBI creates a set of additional measures organized in the predefined measures section Time Tracking.

Original estimated hours

Total of original estimated hours. Used with the Time dimension, grouped by issue creation dates.

Original estimated hours measures is available by default even when the Time tracking measures option isn't selected in import options. 

Original estimated hours resolved

Total of original estimated hours for the resolved issues. They are grouped by issue resolution date in the Time dimension.

Original estimated hours closed

Total of original estimated hours for the closed issues. They are grouped by issue closed date in the Time dimension.

Hours spent

Total of hours spent on issues matching the selected dimension members.  On the Time dimension grouped by the start date specified in the worklog. The Logged by dimension can be used to see hours spent by individual users.

You can Drill through the cell to get a list of all worklog entries constituting particular Hours spent total value, with additional information -user name, date, issue key, worklog comments, as well as logged hours for this entry. The list could be exported to a file.

Hours spent measures is available by default even when the Time tracking measures option isn't selected in import options.

If you use the Tempo app in Jira Cloud, please see how to enable worklog import.

Hours spent resolved

Total of hours spent on resolved issues. They are grouped by issue resolution date in the Time dimension.

Hours spent closed

Total of hours spent on closed issues. They are grouped by issue closed date on Time dimension.

Original estimated hours accuracy %

Accuracy of estimated hours compared to the total time spent on resolved issues in the period.

Average hours spent of resolved issues

Calculates average hours spent on resolved issues with logged time. They are grouped by issue resolution date in the Time dimension.

Issues with Original estimated hours resolved

Count of resolved issues with original estimated hours. They are grouped by issue resolution date in the Time dimension.
Hidden measure.

Issues with Original estimated hours closed

Count of closed issues with original estimated hours They are grouped by issue closed date in the Time dimension.
Hidden measure.

Issues with hours spent

Distinct count of issues that have any hours logged in the selected Time period.

Hours spent measures is available by default even when the Time tracking measures option isn't selected in import options.

Issues with hours spent resolved

Count of resolved issues with hours spent They are grouped by issue resolution date in the Time dimension.
Hidden measure.

Issues with hours spent closed

Count of closed issues with hours spent They are grouped by issue closed date in the Time dimension.
Hidden measure.

Remaining estimated hours

Total of current remaining estimated hours. Used with the Time dimension, grouped by issue due dates for unresolved issues and by resolution dates for resolved issues.

Remaining estimated hours measures is available by default even when the Time tracking measures option isn't selected in import options.

Original estimated hours with sub-tasks

Remaining estimated hours with sub-tasks

Hours spent with sub-tasks

Retrieve Original estimated hours, Remaining estimated hours, and Hours spent values for parent-level issues, including their sub-task issue values; for sub-task level issues, the value is always zero.

Use those measures in reports and calculations in case you need to apply filters on parent issues only; otherwise, use corresponding measures Original estimated hours, Remaining estimated hours, and Hours spent (they include values for all level issues, parent and sub-tasks, based on the report context).

Remaining estimated hours change

Change (increase and decrease) in remaining estimated hours during the selected Time dimension period. For example, if there are logged hours in the period and the remaining estimated hours are adjusted automatically in Jira, "Remaining estimated hours change" would show the change equal to logged hours with a minus sign. On the other hand, if an issue gets estimated in the selected period, "Remaining estimated hours change" would show a change equal to added estimation.

Import issue change history to get this measure. See also

Remaining estimated hours history

Total of remaining estimated hours at the end of the selected Time dimension period for issues that match report filter criteria.

Import issue change history to get this measure.

Properties

eazyBI creates additional issue properties:

Issue Original estimated hours

If the Issue dimension is placed on rows and expanded to detailed issues, then the issue property Issue Original estimated hours shows the original estimated hours for individual issues. 

Issue hours spent

If the Issue dimension is placed on rows and expanded to detailed issues, then the issue property Issue hours spent shows the total time spent on individual issues.