Is there a way to pull a report on JIRA on timespent on issues before a particular status?

Warren McInnes

For example, 

 

We have a workflow where there is a check/status before the issue is closed and need to report on time spent up until then?

 

Therefore i would like to pull a report on all issues from X project up until status X in a certain date range?

E.G. project = "projectX" and last status to be included is "resolved" and created >= "x" and resolutionDate <="x"

 

I do not want to include the timespent from "resolved" to "closed"

 

Hope this makes sense.

Warren McInnes

I managed to use "Better Excel", Would have been great if a 3rd party plugin wasn't required.