Compare all tickets in project against one specific ticket by formula

Andrey Ulianov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 4, 2024

Hey folks, question here.

Trying to use Comments in one specific jira ticket (issuekey=DB-1250) as a reference kind-of-table, as a place to store historical stats about the duration of tasks of different size.

Something like

S:5

M:12

L: 27

Each of these sizes are posted as a separate  comment to this DB-1250 ticket.

Then I have hundreds of other tickets within the same project, which are marked with task sizes. No links or hierarchy to this reference DB-1250 ticket.

Logic I'm tryig to apply is:

Knowing all ticket sizes (S,M,L) from the project,

Retrive the apropriate comment from DB-1250 by keyword "S:", "M:", "L:"

And put this number into formula to calculate the total duration for all the tickets I need.

 

What I cannot understand is how to "hardcode" this issuekey in complarison formulas.

Is there a way to compare all the tickets against that specific one and how to refer to that specific issuekey in formula?

Maybe a hint you can give?

 

2 answers

0 votes
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 9, 2024

Hello @Andrey Ulianov 

If you want to add DB-1250 size from its comments to the size of each other issue, then you can access DB-1250 sizes from the comments and show the values in other issues like this:

1. Add DB-1250 into the structure as the parent issues, and place other issues underneath it as sub-issues. The Formula column can only access values from other issues if these issues are somehow related to issues where you want the values to be shown - either through issue links, or through the hierarchy in the structure.
2. To return DB-1250's size for each issue below it, you can use a formula like this:

parent{split(split(comments,"S:").last(),",").first()}
(this example will extract the S value from DB-1250).

I hope this helps. If you need further assistance or if you have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

 

0 votes
Humashankar VJ
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.
December 7, 2024

Hi @Andrey Ulianov 

In Structure for Jira, create a formula column to calculate ticket durations based on task sizes.

Since formulas cannot directly read comments from another issue (DB-1250), preprocess the data (e.g., S: 5, M: 12, L: 27) into a custom field.

Use a formula like IF(Size = "S", 5, ...) to map sizes to durations and calculate totals.

So ideally you have to research on preprocessing methods / tools for this use case.

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

Suggest an answer

Log in or Sign up to answer