Estimated vs. Logged hours report with Jira

[Dimitrina Ivanova]

Here is a simple but very useful case that we have decided to describe as it took us some time to gather all the information needed 😊

Due to client requirement we had to make a simple report that shows the estimated and logged time related to one service desk ticket and its linked issues and/or sub-tasks without using additional plugins.

The catch was that the estimate is in the Service desk issue and the logged time was in the linked issues and/or sub-tasks and, we had to keep it real even if the worklogs were edited or deleted.

So, we have made an Automation Rule with 2 branches – one for the sub-tasks and one for the linked issues.

As there was no option to directly sum the logged hours in the related time tracking fields and also to make it more readable for the client, we have made 3 custom fields – one number type for the sub-tasks logged time sum, one number type for the linked issues logged time sum and one text field that shows the amount of the above two all shown in man days:

After that for the report itself we have created a dashboard with Filter Result gadget and here is the final view:

Check the automation below. We hope that will help someone not to struggle too much if similar case appears 😊

The TimeSum is calculated in both cases like:

{{#=}}{{SumSubTasks}}+{{issue.SumLinkedIssuesTime}}{{/}} days

for the sub-tasks and

{{#=}}{{issue.SumSubTasksTime}}+{{SumLinkedIssues}}{{/}} days

for the linked issues.

Cheers,

Dimitrina