Time tracking measures
eazyBI for Jira
Available for eazyBI for Jira Cloud and starting with 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 resolved | Total of original estimated hours for the resolved issues. They are grouped by issue resolution date on Time dimension. |
|---|---|
| Original estimated hours closed | Total of original estimated hours for the closed issues. They are grouped by issue closed date on Time dimension. |
| Hours spent resolved | Total of hours spent on resolved issues. They are grouped by issue resolution date on 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 from resolved issues with logged time. They are grouped by issue resolution date on Time dimension. |
| Issues with Original estimated hours resolved | Count of resolved issues with original estimated hours. They are grouped by issue resolution date on 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 on Time dimension. Hidden measure. |
| Issues with hours spent resolved | Count of resolved issues with hours spent. They are grouped by issue resolution date on Time dimension. Hidden measure. |
| Issues with hours spent closed | Count of closed issues with hours spent. They are grouped by issue closed date on Time dimension. Hidden measure. |
| 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 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 matche report filter criteria. Import issue change history to get this measure. |
Please see the description of the rest of the Time Tracking measures here:
Properties
eazyBI creates additional issue properties:
| Issue Original estimated hours | If 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 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. |