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

[Hannes Obweger - JXL for Jira · Accepted solution]

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 

[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

[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

[Alain Beaulieu]

@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.

[Hannes Obweger - JXL for Jira]

Hi @Alain Beaulieu

thank you for reaching out!

Regarding your specific use case: JXL comes with a powerful conditional formatting feature, so highlighting certain values generally works great:

The tricky part would be the dependencies between different fields and values: E.g., I understand that you would have to sum up (combine) two values, and compare it to the issue's SLA. That's not currently possible in JXL (however, will be in the future!), and you'd have to workaround this via some kind of scripting, e.g. Jira Automation. I.e., you'd do the math in your script, write the result into a custom field, and then use the custom field in JXL to do the highlighting.

Regarding customised demos: The easiest would be to reach out to us at https://jxl.app/support with a brief summary of your use cases - we can then take it from there!

I would also recommend to watch our quick demo video, if you haven't yet - it should give a good overview of JXL's features and capabilities.

Any further questions just let me know,

Best,

Hannes

[Stepan Kholodov _Tempo_ · Accepted solution]

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]

Hi Stephan, 

Thank you. It worked :)

Eszter

[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

[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