I created a new status in JIRA named 'Blocked' and some of the tasks were kept in that status, but when generated Lead Time report, it's including the time on that 'Blocked' state as well, actually need to have time excluded from my Leadtime.
I am not sure, if I have to create 'Block' status in any specific way to achieve this. Our Workflow is as below:
To Do -> In Progress -> Blocked -> If unblocked -> In Progress -> done.
If you are interested in a ready-to-go solution, our team at OBSS created Time in Status app for this exact need. It is available for Jira Cloud, Server and Data Center.
Using Time in Status you can report how much time each issue spent on each status, each assignee or even each user group. (useful for calculating lead/cycle times and identifying bottlenecks in your process). You can also see the number of times each status or transition was used (very useful for inspecting things like reopen counts). You can also list the status entry/exit dates.
You can produce reports based on the default 24/7 calendar or define your own business calendars with custom workdays and working hours.
All data can be exported as XLS, XLSX, CSV so you can calculate the sum of any group of columns you need.
You can try the build-in solution Control Chart to get lead time.
But if you want pause time calculations you can try the free trial version of Time between statuses. This add-on will show you the Lead and Cycle time report after the configurated start, pause and stop statuses.
There are you can customize what kind of transition is interesting for you: "first" or the "last" transition, "to" or "from" the status. Also, you can set the visual color tagging on the issues where the time limits have been exceeded.
I hope, this add-on will be a great solution for you.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events