Metrics Reports for Kanban: Lead Time/Cycle Time/Throughput

[Evelyn Dieppa]

Hello!

I have just started measuring the following 3 Kanban metrics for one of the development teams I lead. 

Lead Time - from Create Date to Resolution Date

Cycle Time - from the moment issue gets picked up out of "to-do" into "in progress"

Throughput - # of issues closed per month 

Lead time and throughput are easy. I can use fields in Jira. I just create a Jira filter, extract the data I need, pull it into Excel and create easy Pivot tables. 

What I need help with is Cycle Time. Is there any way in Jira that whenever an issue moves from one particular status (To Do) to another (In Progress), that a field is updated like "Date Picked Up"? 

This would be a time saver as I'm doing this  now manually. 

Cheers,

[Tarun Sapra · Accepted solution]

Are you using ondemand or self-hosted JIRA, as you would need Script Runner plugin for these kind of searches. Script runner plugin is only available on self-hosted.

see here- https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-Subtasks

[Sanjay Nanda]

Thanks Tarun and Sakthi for the reply. I could use Script Runner to achieve this. Below is the query:

issueFunction in subtasksOf("status = Committed") AND status != Committed AND assignee = <loginid>

[Sakthi Balaji]

Hi Sanjay,

can you pls try with this JQL QUery in the advance search issues screen

project = "project_name" and status != "ur required status" and issue in subtaskIssuesFromQuery("project = 'project_name' and status = 'ur required status' ")

[Sakthi Balaji]

You can add assignee ="ur name in the query"

and whatever criteria you wanted in the query