Compare all tickets in project against one specific ticket by formula

[Andrey Ulianov]

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?

[Stepan Kholodov _Tempo_]

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)

[Humashankar VJ]

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