Summing Estimate & Time Spent to report at Project Level

[Martin Finch]

Good Morning,

I apologise if this is something which is fairly simple to achieve in a JIRA dashboard but I can't get it to work for me.

I'm creating a dashboard to track project progress. Our Original Estimates and Time Spent are logged at Task &/Or Epic level. What I want to achieve is a summary of Time Spent and Original Estimate at Project Level i.e. a sum off all the time spent and original estimates in the tasks/epics which are linked to a Project (i hope that makes sense)?

Ideally i want to show this in an Issue List widget in a JIRA dashboard - is this possible and if so how do i achieve it?

Thanks in advance

Martin

[Mykenna Cepek]

This is rather challenging to do in Jira "out of the box". People typically take one of three approaches:

• Export data from Jira and play with spreadsheets (horribly manual)
• Set up awkward and complicated Automation Rules (overly complex)
• Use a third-party add-on App for Jira that is good at this (added cost)

I've done this at a number of organizations. Normally I don't appreciate it when people recommend add-on Apps, since they cost extra. But in this case I would highly recommend one: Tempo Timesheets.

https://marketplace.atlassian.com/apps/6572/timesheets-by-tempo-jira-time-tracking?tab=overview&hosting=cloud

I know, it doesn't sound like a "timesheet" app is what you want. But take a look at what it does. Make use of a Free Trial (in a Jira sandbox, if you're on Cloud). Some things I like about it are:

• Aggregated reporting (your main goal) is beautifully implemented. Fixed reports and ad-hoc reports are very easy to set up.
• A whole bunch of Jira Dashboard gadgets are included.  <3  (that's a heart).
• Categorization capabilities (which you will soon want) are incorporated and easy to use.
• Features are included that enhance Jira to make it easier for users to enter, see, monitor, and correct their time entries.

If "time tracking" is a thing that's important to your business, I believe that Tempo Timesheets is worth the cost.

I have no relationship to Atlassian, any Marketplace Vendor, or Tempo. I'm just a user, and have had great success with Tempo at multiple organizations.

[Marlene Kegel - codefortynine]

Hello @Martin Finch,

I am Marlene, product manager of Quick Filters of Jira Dashboards.

With our app you can also sum up estimates and any other Jira number field. 

You can check out our app without installation on our demo dashboards.

[Mykenna Cepek]

I see a bunch of answers here trying to address the "visibility" aspect of your requirements - how the results will appear.

But I suspect we haven't spent adequate time exploring the filtering/categorization that you need:

What I want to achieve is a summary of Time Spent and Original Estimate at Project Level i.e. a sum off all the time spent and original estimates in the tasks/epics which are linked to a Project (i hope that makes sense)?

It actually doesn't quite make sense to me yet. Issues belong to a Project. Issues can only Link to other Issues. I'm using the capitalized Jira terms here very specifically.

When you say "tasks/epics linked to a Project", that doesn't make sense in strict Jira terminology (since Tasks and Epics are Issues, and they can't "link to a Project").

[Hannes Obweger - JXL for Jira]

Hi @Martin Finch

if I may add another Marketplace recommendation, I think you might like the app that my team and I are working on, 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, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. 

With these, you can build a report l like e.g. this in just a couple of clicks:

It's really as simple as this - and this is just one example; you can also group by any other (combination of) issue fields, use a different sum-up style... it all just depends on what information you'd want to get out of it.

As you can see above, any report remains fully interactive and updates live as you make changes.

Any questions just let me know,

Best,
Hannes

[Amay Purohit_RVS]

Hi @Martin Finch 

As suggested by others, an app can help you get this data. If you are open for the same, you can try out

Issue Hierarchy 

Through this app you can view all the issues for a specific project in a tree structure. And the app rolls up the time spent at each parent level. You can add it as a dashboard gadget and export the data to a csv too.

Disclaimer : I am part of the team which developed this app