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

[Martin Härri]

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)

[Stepan Kholodov _Tempo_ · Accepted solution]

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: https://tempo-io.atlassian.net/servicedesk/customer/portal/6/group/1051

Best regards,
Stepan Kholodov
Tempo

[Martin Härri]

Thanks, I'll try this out!