Is there a similar function in Structure for Jira like "key in issueInEpics"?

Martin Härri June 10, 2023

For some rather elaborate progress tracking reasons I would like to build a formula which counts the story points of issues only if their epic meets certain criteria.

In JQL I use the function above (I think it's from PowerScript), is there something similar in EXPR? Something like (if(epic of this story meets certain criteria;storypoints;0)

1 answer

1 accepted

0 votes
Answer accepted
Stepan Kholodov _Tempo_
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.
June 29, 2023

Hello @Martin Härri 

 For example, you can do it in the following scenario:

  1. Create a structure with Epics at the top level and Stories under each of their parent Epics.
  2. Add the Formula column with a formula like this:
    if issuetype = "Story" and parent{if issuetype= "Epic" and ... : storypoints}
    where ... should be replaced with an additional condition. Then you can sum up the values in column for each Epic by enabling the 'Sum over sub-items' option in the column's configuration or by using the sum aggregate function.

I hope this helps. If you have more questions, please reach out to us directly at our portal:

Best regards,
Stepan Kholodov

Martin Härri July 1, 2023

Thanks, I'll try this out!

Like Stepan Kholodov _Tempo_ likes this

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events