Jira Structure question

[Kristina Volokhovska]

Hi, 

I have a use case around epics where I need to see a side by side comparison between number of tickets added to an epic before a specific date and what's the list at present. That would be used to analyse scope creep for example.  

Currently, I have a structure with a list of epics and linked tickets, then in 2 separate columns I'm aggregating count of children and sum of story points. 

However, I also would like to have aggregate values of linked tickets that were linked before epic start date. I have a JQL query that I use to grab is separately, something like "Epic Link" = TEST-123 AND created <= "2020/7/8", which could give me less tickets than this epic has now for example. 

Does Structure support such a case? Is there a way to make calculations for tickets that are not currently in structure? 

thanks

[Marlene Kegel - codefortynine]

Hi @Kristina Volokhovska ,

I believe your use case is possible with our app Dynamic Fields for Jira.

As an example I created a field that displays the numbers of issues that were added after the epic was set to in progress.

Since Dynamic Fields is using expressions to compute custom field values, it's very flexible. So it could be adapted if my example doesn't reflect your use case.

This is how it could be displayed within the epic:

This is how the expression would look like:

issue.changelogs.flatMap(changelog => changelog.items).some(item => item.field == 'status' && item.toString == 'In Progress') ? issue.changelogs.flatMap(changelog => changelog.items) .reduce((result, item) => result.some(item => item.field == 'status' && item.toString == 'In Progress') || (item.field != "Epic Child" && (item.field != 'status' || item.toString != 'In Progress')) ? result : result.concat([item]), []).length - 1 : 0

Of course you can use the field "unplanned work" for your dashboards and statistics.

If you have questions or feedback don't hesitate to get in touch with our support. We would appreciate to help you to create your custom dynamic field.

Best regards,

Marlene

[Mario O.G]

Hi Kristina,

Structure doesn't give the ability to fetch the date a link was established between two items.

We can use the formula below to sum up the issues that were created after a specific date, but we can't specify links.

sum{if(created > DATE("2020-01-01"); 1)}

Note that this formula will count all issues added after the specified date, which means that below the epics, you'll also see a count of the new issues created since that time.

I hope that helps! Feel free to contact us at support@almworks.com if you need more specific support.

Thank you for using Structure.

Mario O.G
[ALM Works]