Automated Email of EPIC % complete

[Dave White]

Hi There: 

We have Jira Cloud, and we need to produce a weekly email of the completion percentage of active Epics, plus an Epic Complete email.     I think I can figure out how to use Jira Automation to send out the EPIC complete email, but no clue how to send out the % complete email automatically. 

This is fairly urgent and would greatly appreciate any help in any form.  :)

thanks, 

K Dave White, Sr. Technical Scrum Master, DevOps

[Dave White]

I finally created a Python script to use the stories statuses to calculate the % complete.   By applying a weight to the status, we get a better representation of the %complete.   We also add a Percent Complete field to the Epics for the report.   I'm now in the middle of doing transport of Jira data to Sharepoint in order to create dashboards on Sharepoint (not everyone has access to Jira). 

thanks everyone. 

[Dave White]

Additionally, referencing:   

Previous Community post about getting Epic percentage weekly   -  this will give me the % value, so I'm just looking for setting up an email rule for this.     (I'm fairly new to Jira Automation). 

thanks so much!!!

Dave

[Trudy Claspill]

Hello @Dave White 

How would you calculate Epic completeness?

The percent complete shown in the Epic itself is based simply on the count of child issues, with the "% Done" measure counting those that are in a status that is part of the Done Status Category  (the green statuses, vs. the blue and gray statuses).

If that is the number you want, be advised that number is not stored as a piece of data in the Epic. It is calculated on demand when you are viewing the Epic.

An Automation Rule could be constructed to make that calculation for an Epic.

My automation skills are enough that I could tell you how to send one email for each Epic, but not such that I know how to send on email that contains that information for all Epics. I think the latter could be done, but I haven't spent the time to figure out how to do it. There are other people in the community with ninja skills in automation that can hopefully weigh in.

Alternately you could construct an automation rule that actually recorded that value into each Epic. Then it would be fairly simple to generate another rule that would send out an email with the list of Epics that included that value for each Epic.

[Dave White]

thanks Trudy!   unfortunately, I think I'd have to nest the rules to be able to first create the inserted % complete field and then JQL that would pull a list of Epics displaying that field and send an email. (not straightforward).    Hoping someone sees this and has some examples/answers for me to run with.  

Dave

[Trudy Claspill]

Hello @Dave White 

I provided the answer on the post you referenced:

Previous Community post about getting Epic percentage weekly

:-)

To send the result as an email you would use the Send Email action. However, as I mentioned above, that will send an email for each Epic, not a single email listing all Epics. Is an email per Epic an acceptable solution?

[Dave White]

if I can't figure out how to send a report for all I think we can live with it.  We're the DevOps team(s) and Epics don't get "done" often.    but, I think he'll want to expand it to the web development team.   Do you know anyone familiar with REST api.   I could write a python program to pull data and push out emails if it comes to that.   Just seeing how far I could take automation before I resort to that

thanks,

Dave