Hi. What JQL can I use to calculate the time from when an issue moved from status TO DO to DONE

[Kasturee]

What JQL can I use to calculate the duration from when an issue moved from status TO DO to status DONE

[Janis Plume _eazyBI_]

Hi,

eazyBI add-on for Jira offers various reporting features related to the Jira and popular add-on data. There is a standard measure in the data model of eazyBI calculating the time issue spent for some status.

Please, have a look at the eazyBI documentation here or here for more information. You can check the possible reporting features on the demo account.

Best regards,
Janis, eazyBI support

[Lime Trees]

Hi,

Do you really need to use JQL to get this duration? If not necessary, you can have a look at our free add-on Status History.

Cheers,

Lime Trees Support Team

[Ignacio Pulgar]

JQL can only return issues, and you can set it to show created date an resolved date.

That said, you've got several ways to calculate the difference between both dates:

1. exporting the results and calculating the date diff through spreadsheet functions
2. use a third party plugin, like ScriptRunner scripted field for registering that difference, Jira Misc Custom Field's calculated field, this or this, eazyBI report...

The first approach doesn't need any third party plugins.

Hope it helps.