Time tracking report for estimates versus reality (logged time)

[Pavel Kovařík]

Hi, 

I want to create overview report for whole project. I need to see estimations of all task and also logged time for them. Idealy filtered as sum of Epic, and single tasks under it. It would be great to use something like Time Tracking Report in Tempo, but there is a problem, that it will not display issues without any worklogs. I was thinking about adding 1m log to all issues, buts that not a good way. 

Something like this, but for all issues whatever they have logged time or not:

Any suggestions? Im also open to paid plugins.

Thanks! 

[Kathryn Vargas _Tempo_ · Accepted solution]

Hi @Pavel Kovařík

I'm part of the team behind Structure (which is now part of Tempo), a project portfolio management app that lets you organize, view, and manage projects in any custom issue hierarchy, in one spreadsheet-like view. 



It also lets you group issues as you need, add any Jira field as a column, and get sum-ups for numeric values like Time Spent, Original Estimate, and Tempo Work Logged, a column that will help you achieve exactly what you are trying to solve. 

The Tempo Work Logged column in Structure lets you pull in the logged and billable time data from Tempo Timesheets so that you can view time data alongside any issue hierarchy, and have those values sum-up all the way to the parent (in your example, Epic) for quick and easy reporting.

If time hasn't been logged to an issue, it will appear blank in Structure, as you can see in the screenshot. 



Structure is free to try for 30 days – feel free to check out how it works with Tempo Timesheets! 

Hope this helps, 
Kathryn

[Pavel Kovařík]

Hi Kathryn, 

this looks great! I will definitely try it! Thanks! 

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Pavel Kovařík

my team and I are working on a Marketplace app that I think might be helpful to you: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting and filtering by all your issue fields, including all time tracking fields. You can also view your issues in customisable issue hierarchies and groupings, and calculate sum-ups across these structures.

Here's how a sum-up to epics and then to projects could look like (I just set this up really quickly in a minute or two):

OE = original estimate, and TS = time spent. JXL also supports Tempo's app specific fields (Team, Account) if this is useful.

Any questions just let me know,

Best,

Hannes

[Nataliya Vasyliv_Reliex_]

Hi @Pavel Kovařík 

As one of a many features of ActivityTimeline is "Issue Planned vs Actual Report". If you considering using a resource planning plugin ActivityTimeline, you can generate such report by using addon.

[Gaurav]

Hello @Pavel Kovařík 

In my experience, we can use 'Time Tracking Report in Tempo' for effort logging but I am not well versed with the reporting capabilities.

We had created a similar report using the plugin, 'eazyBI for Jira', where we could view the Epic level and expand the report if required. You may explore this as well.

Hope this helps.

--GG

[Pavel Kovařík]

Time Tracking Report in Tempo is great, but shows only issues with logged time I also need to see big picture for project :/. 

Thanks! I will have a look at eazyBI :)  

[Kathryn Vargas _Tempo_]

Hi @Pavel Kovařík

I'm part of the team behind Structure (which is now part of Tempo), a project portfolio management app that lets you organize, view, and manage projects in any custom issue hierarchy, in one spreadsheet-like view. 



It also lets you group issues as you need, add any Jira field as a column, and get sum-ups for numeric values like Time Spent, Original Estimate, and Tempo Work Logged, a column that will help you achieve exactly what you are trying to solve. 

The Tempo Work Logged column in Structure lets you pull in the logged and billable time data from Tempo Timesheets so that you can view time data alongside any issue hierarchy, and have those values sum-up all the way to the parent (in your example, Epic) for quick and easy reporting.

If time hasn't been logged to an issue, it will appear blank in Structure, as you can see in the screenshot. 



Structure is free to try for 30 days – feel free to check out how it works with Tempo Timesheets! 

Hope this helps, 
Kathryn 

[Madhu_RVS]

Hi @Pavel Kovařík 

If you are fine with a mktplace app to get this data, we have created an add-on to track the progress of your projects at each Issue hierarchy level.

Issue Hierarchy Reports