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?
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.