Need to get the count of all stories vs resolved stories linked to an epic through automation

[Nawaaz SOHAWON]

Requirement:

Need to have a % progress of resolution of an Epic using the below calculation:

Number of Resolved Stories in an epic/Number of All Stories in the epic

I cannot find any smart values for the link between Stories and Epics.

For example: For normal links, we can use: {{issue.issuelinks.Issue....}}

Are there any specific smart values for this Epic Link?

Note: I cannot use Lookupissues since I am trying this on a data center.

Regards,

Nawaaz

[Trudy Claspill]

Hello @Nawaaz SOHAWON 

In this post

https://community.atlassian.com/t5/Jira-questions/Check-issue-count-while-using-Jira-automation-Jira-Server/qaq-p/1781574

@Bill Sheboy suggests that you can use the smart value {{issues.size}} to get the count of issues for a JQL executed as part of a Schedule trigger on Jira Server/Data Center. If you can use the Schedule trigger to run your rule periodically to calculate the progress of an Epic, this might satisfy your need.

[Nawaaz SOHAWON]

Hello @Trudy Claspill ,

Thanks for your prompt answer.

The fact that I need 2 counts for resolved stories as well as ALL stories cannot fit with this solution.

I cannot seem to create a JQL which would retrieve all Stories and also stories which have just moved to "Done". 

Any ideas?

Regards,

Nawaaz

[Trudy Claspill]

What you could do is add two custom fields to your Epics; one for the count of all stories and one for the count of Done stories.

Run two rules to get the list for each and update the custom field.

Have a third rule to calculate the progress.

[Nawaaz SOHAWON]

Thanks @Trudy Claspill 

[Trudy Claspill]

Hello @Nawaaz SOHAWON 

Have we provided enough information for you to solve your requirement?

If so, please consider marking the Answer thread as Accepted to help other users find posts that contain working solutions.