How to measure Kanban Backlog duration time?

[Sultan Hassan]

Time duration in Backlog?

[Bloompeak Support]

Selam @Sultan Hassan 

It is not possible out-of-the-box in JQL. You can calculate it by coding which parses issue history rest api json for each issue. Or you can search for marketplace apps which does the same for you.

You can try Status Time app developed by our team. It provides reports on how much time passed in each status as well as status entry dates and status transition count.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports(eg. average in progress time per project). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

[Trudy Claspill]

Hello @Sultan Hassan 

Welcome to the community.

There are many posts in this community already that cover the topic of reporting on the "time in status" for an issue. There are ways to do it with vendor apps, and there are some ways to do it without vendor apps.

Here is one that summarizes multiple options:

https://community.atlassian.com/t5/Jira-questions/How-to-track-amount-of-time-spent-in-status/qaq-p/590835