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?

 

1 answer

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