CANNOT USE ADD-ONS Need to calculate Average time between 2 statuses

[Rachel]

I need to figure out the average time it takes an issue to go from status A to status B. I cannot use a plug in or an add on. 

[Shikha Verma · Accepted solution]

Welcome to the community @Rachel 

Create a JQL Filter, then Export to CSV (Export the filtered issue list, including history fields, to a CSV file) and then Analyze in Excel/Google Sheets: 
Extract the dates when issues transitioned between Status A and B.
Calculate the time differences for each issue.

This will help you to calculate the average manually using spreadsheet. 

[Bill Sheboy]

Hi @Rachel -- Welcome to the Atlassian Community!

With no marketplace addons, you could try the built-in control chart: https://confluence.atlassian.com/jirasoftwareserver/control-chart-938845628.html

There are known issues / limitations for that chart so read through the article to learn more about those.

Kind regards,
Bill