Sum up time tracking datata on linked issues (not -parent-child)

Eszter Somossy February 25, 2024

Hi,

 I am struggling with the following task:

I want to sum up original estimated time, remaining time, spent time, logged time data from issues, that are linked with 'created by' to issues in a specific issuetype.

They are in parent linkage (created - created by)

I use Jira Cloud Standard + Tempo Timesheets, Planner, Structure + Epic Sum Up add on.

Is it possible?

Thanks for answer.

Eszter

 

3 answers

2 accepted

0 votes
Answer accepted
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 28, 2024

Hi @Eszter Somossy

if you are open to solutions from the Atlassian Marketplace, I think you'd 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 like e.g. this in just a couple of clicks:

sum-up-time-over-linked-issues.gif

This is really just one of a virtually endless number of possible views and reports - you can freely configure your issue hierarchies and structures, use different sum-up techniques, etc. etc.

Any questions just let me know,

Best,

Hannes 

Eszter Somossy March 3, 2024

Hi Hannes,

I had already added JXL for Jira before. I really am very satisfied with this excellent useful and handy addon.

I also want to sum up in Structure and on Jira parent tickets.

Best regards,

Eszter

 

Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 3, 2024

Wonderful! Any further questions, ideas, or feedback, please reach out anytime to us via https://support.jxl.app!

Best,

Hannes

Like Eszter Somossy likes this
0 votes
Answer accepted
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

Hello @Eszter Somossy 

You can do it in Structure this way, for example:

1. Add parent issues of issues that you want to work with using the Insert generator.
2. Add their linked issues using the Linked Issues Extend generator by configuring it to the 'created by' Link Direction.
3. Add the Formula column with a formula:
sum{originalestimate+remainingestimate+timespent} and set its format to Duration. 

As a result, the formula will sum up individual estimates of linked issues and show the aggregated value above them for each of their respective parents.

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

Eszter Somossy March 3, 2024

Hi Stephan, 

Thank you. It worked :)

Eszter

0 votes
Amay Purohit_RVS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

Hi @Eszter Somossy 

As an alternative, you can try out the add-on we have developed for the same use case.

Issue Hierarchy 

The app rolls up the time spent / story points progress at each parent level. You can add it as a dashboard gadget and export the data to a csv too. 

Also the app allows to filter child issues of a particular link type.

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

Links HIerarchy.PNG

Eszter Somossy March 3, 2024

Hi Amay, Thank you but I had already add Structure and JXL before. I hope these will be enough for what I need.

Kind regards,

Eszter

Like Amay Purohit_RVS likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events