Report based on number of time JIRA workflow status changes.

[Smitha kumari]

Hi Team,

I would generate a report based on status chages of the subtasks. I have created Subtasks with Work in progress to review & Review to in progress back. Wanted to see how many times subtask moved from Review to inprogress with in the given period like 5 times, 3 times etc.

Thanks.

[saravanan subramanian]

Add another custom field called counter - and increment the counter at the post operation. you can use that field to display it in the JQL and also export it into excel

[Imdad KP]

Hi @Smitha kumari,

This may help you, you need to install following free add-on for the same https://marketplace.atlassian.com/plugins/com.googlecode.jira-suite-utilities/server/overview

image2016-10-24 12:39:47.png

Thanks 

[Smitha kumari]

Thanks for this. But I am looking for generating Excel based report from the Query. Can we get execution times on the Query output.

Regards,
Smitha