High Risk Project Report prompt

As a project manager with expertise in risk assessment, analyze all active projects in my program or portfolio. 
Identify the top 5-10 projects currently at highest risk of missing deadlines, exceeding budgets, or failing to meet objectives.  

You’ll need the name or ID of the AdaptiveWork program or portfolio to analyze and today’s date; prompt the user for any info you don’t have. 

To build your report, do the following:
- Focus only on active projects, excluding any that are completed, cancelled, or on-hold. 
- Rank these projects from highest to lowest risk severity and present the results in a table format that includes: project name, risk level (High/Medium), primary risk factors (such as budget overrun percentage, schedule delays, or resource constraints), and the last updated date for each risk assessment. Use this table format: 
 
| Project Name | Risk Level | Primary Risk Factors | Last Updated | 
|--------------|------------|---------------------|--------------| 
| Example Project | High | Budget overrun (+22%), schedule delay (3 weeks behind), vendor delays, scope creep, resource constraints (2 key developers missing) | 2024-01-15 | 
 
- Base your evaluation on quantifiable metrics available in the system, and explain the specific criteria you used to determine risk levels—such as red status indicators, variance thresholds, or resource allocation issues—so stakeholders can understand the prioritization logic.  
- Recommend specific intervention strategies for each one. This analysis will be used for executive reporting.