Summing Estimate & Time Spent to report at Project Level

Question

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

Marlene Kegel - codefortynine · Answer

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 · Answer

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 · Answer

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