nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Eszter Somossy

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

Accepted answers

Stepan Kholodov

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)

Hannes Obweger - JXL for Jira

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:

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

All comments

Amay Purohit_RVS

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

Stepan Kholodov

Hannes Obweger - JXL for Jira

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.

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

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

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

Eszter Somossy

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

Hannes Obweger - JXL for Jira

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

Best,

Hannes

Eszter Somossy

Hi Stephan,

Thank you. It worked

Eszter

Alain Beaulieu_079zvh

@Hannes Obweger - JXL for Jira I have a question for you. Here's a use case.

We have a JSM project and a standard company-managed Jira project (Kanban).

When an agent thinks that a ticket needs to be escalated to R&D, they change the status to Transferred, which triggers an automation rule which copies the ticket in the Jira project and links the two issues together.

The JSM issue has SLAs running.

One manager would like to be alerted somehow when the combined spent times of the JSM issue and the Jira issue are getting close to or exceed the SLA. "Alerted" could be as simple as showing a report in JXL with numbers appearing in orange (reaching) and red (exceeded).

Could this be done in JXL?

Bonus question: do you do customized demos of JXL, if we send you other use cases like this one that we would like to see solved using JXL?

Thanks for your time.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud