I am running monthly reports from Jira SD for customers. I get a data dump from the filter section where I have save some reporting templates and export into CSV format in excel. The problem begins here...currently the time to resolve field show the time left on the SLA clock... not the time it took to resolve the issue. This means I have to create another column and formula to calculate the hours to resolve. In addition "time to resolve" is in format that difficult to work with and use (basic I need just the number of hours to resolve the ticket).
Recommended Learning For You
Level up your skills with Atlassian learning
Atlassian DevOps essentials
Learn how to build, automate, and improve DevOps processes used for the development and delivery of software and other digital products.
Tracking and improving DevOps metrics
Make informed decisions about current and future projects and deadlines to maximize your team's productivity and keep morale high.
Exploring Atlassian Cloud products for agile and DevOps
Coordinate a suite of Atlassian Cloud products for greater collaboration and trust, higher-quality solutions, faster releases, and more.