I am using a Rovo Agent to provide stats on our sprints. I'm having issues getting the agent to produce correct and consistence results on the total count by status. The JQL produced by the agent is correct and yields the correct results. However, the table that the agent produces does not yield correct results. Any assistance would be greatly appreciated. Here's my instructions:
"- Prompt the user for the sprint name or ID if not provided.
- Search Jira for all tickets within the specified sprint using the appropriate JQL.
- Group the tickets by their current status (use the statuses present in the sprint).
- Output a table with statuses as rows and the count of tickets as the column.
- Add a final row showing the total number of tickets in the sprint.
- As a bullet above the table, display the JQL used for the query.
- Verify that the total count in the table matches the number of records returned by the JQL. If not, recalculate and display an error message.
- If no tickets are found or the sprint is invalid, display an appropriate message.
- If the total does not match the number of records returned, recalculate and display an error message."
