Automation Help - Sprints, Reporting

[Dylan Lenton]

I'm doing some testing to try to automate some reporting aspects of the organization. Currently using Jira 9.12

Right now we're testing out using some of the plan/program views for C-Suite staff. 

I'm testing out different ideas on automating certain status updates. 

One that I've been thinking about is flagging projects based on risk conditions being met. 

For example: if I were to have a sprint complete and the team missed 25% of their planned story points, would I be able to update a field?

Or another scenario could be based off of time logs, if the estimate is 5 days, the due date is 3 days out and only 1 day of work has been logged, triggering some kind of alert actions? Sprint completion seems to be the more pertinent option as I think the granularity of individual issues would not be helpful at an executive level.