Metrics on Jira Labels

Question

Hi everyone, - hoping someone can assist me with my question...

Is it possible to obtain metrics from the moment a label is added to a ticket to the moment the ticket was resolved/closed?

For example

Ticket created on Mon

Label added on Wed

Ticket resolved on Sat

Would I be able to see the time elapsed between when the label was added Wed  through the ticket closure on Sat?

Thanks in advance for any information provided!

Pankaj Jangid · Answer

More or less what @Oday Rafeh has already suggested...

Yes, it is possible to obtain metrics on Jira labels that include the time elapsed between when a label was added to a ticket and when the ticket was resolved or closed.

You can use Jira's built-in reporting and filtering features to generate such metrics. Here are the steps to follow:

* Create a Jira filter that includes the relevant label(s) and the time range you are interested in. For example, you can create a filter that includes all tickets that were labeled "urgent" and resolved between January 1, 2022 and February 28, 2022.

* Once you have your filter set up, you can use Jira's reporting features to generate metrics based on the tickets that meet the filter criteria. For example, you can generate a report that shows the average time elapsed between when the "urgent" label was added and when the ticket was resolved or closed.

* You can further customize your metrics by adding additional columns, filters, and sorting options to the report. For example, you can group the report by assignee to see how long it took each team member to resolve tickets with the "urgent" label.

Overall, Jira provides a wide range of reporting and analytics capabilities, and you can use them to obtain detailed metrics on your labels and tickets.

Oday Rafeh_2jhprw · Answer

Hi @Andrea Hardy

You can achieve this using a combination of Jira Query Language (JQL) and some manual calculations.

Run a JQL query to find the issues with the specific label and resolution status:

labels = "<your_label>" AND resolutiondate >= startOfDay(-7d) AND status in (Resolved, Closed)

Adjust the time range based on your requirements.

Export the results of the query to a CSV file. Make sure to include the "Created, " "Resolved, " and "Issue history" fields.

Open the CSV file in a spreadsheet application like Excel or Google Sheets.

Filter the "Issue history" column to find the events when the label was added. You might need to use some text manipulation functions to extract the dates when the label was added.

Create a new column to calculate the difference between the date the label was added and the "Resolved" date.

Use the calculated column to analyze the time elapsed between the label addition and the ticket resolution.

To automate this process or get more advanced reporting, you might need to consider using third-party apps from the Atlassian Marketplace or develop custom scripts using the Jira REST API.