I created a prompt to be rerun at the end of each sprint but the results are inaccurate. How can I i

This isn't a prompt problem, it's a known limitation. Rovo doesn't see all your issues. It samples a partial set (around 50 in agent contexts), so any calculation across a sprint will be wrong and different each run. The silent failure is a tracked Atlassian bug (ROVO-615): big requests hit an internal cap and die with no error.

The fix: don't let Rovo do the math. Let Automation count, let Rovo write.

1. Jira Automation rule with trigger: Sprint completed
2. Lookup Issues action with JQL like project = XYZ AND sprint = {{sprint.id}}
3. Get exact numbers with smart values: {{lookupIssues.size}}, {{lookupIssues.Story Points.sum}} (run separate lookups for done vs. rolled-over)
4. Pass those computed numbers to your Rovo agent in the same rule. Its only job is writing the summary, not calculating it.

Rovo can't get the totals wrong if it never produces them.

Why your agent failed: agents can't run on their own. They must be invoked from an Automation rule (agent config, then Triggers). If you gave it JQL to search itself, you hit the ~50-issue ceiling.