I am seeking a way to produce a report in JIRA that can provide predicted completion dates for tickets based on the following criteria:
- Rank of the Ticket
- Assigned Developer for the Ticket
- Estimated Hours Required for the Ticket
- Current Status of the Ticket (In Progress, In Development Queue, Completed, On Hold, Etc.)
This report should ideally indicate the expected completion date of each ticket, taking into account that each developer works on only one ticket at a time, follows the ticket ranking, and adheres to the estimated time for completion.
Furthermore, the report must factor in an 8-hour workday while excluding weekends. It would be beneficial for this to be customizable per developer to account for those who work part-time.
Additionally, a bonus feature would be to show the remaining hours assigned to each developer’s tickets.
Are there any existing reports that fulfill these requirements? Also, I would appreciate any suggestions on how to create such a report.
Thank you for your assistance.