nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Count the number of days in a column

alessandro_romolo_e

Dear all,

there is a functionality in Jira that allows to see how many days the ticket has been in the column: these are the dots on this ticket.
The problem is that, when I take a ticket from the backlog, it appears that the ticket has been in the column "to do" of the sprint since several weeks, simply because it has the same status.
How can I use this functionality to verify how many days the ticket have been in the sprint, and not since the creation?

I tried to change the status automatically when the ticket is in the sprint, but this doesn't change the situation, because the first column includes the status "Backlog" and the status "To do". And if I try to remove the status "backlog" from my Scrum Board, all the "Backlog" tickets are not visible in the Backlog.

Accepted answers

Bill Sheboy

Hi @alessandro_romolo_e -- Welcome to the Atlassian Community!

For a company-managed project, the solution for this behavior is to have a separate status for the leftmost column of your board which is different from the backlog. For example:

Backlog
- status is "Backlog"
Board
- leftmost column status is "To Do", "Selected", or whatever works for your team
- ...other board columns

Kind regards,
Bill

All comments

Asad_nq9sbm

Hi Alessandro! Welcome here! Could you please try following solutions:
Do Board Configuration which means review your board configuration to ensure that backlog and sprint columns are properly separated. Automation Rule which means set up an automation rule to change the status of an issue when it's moved into a sprint. This could help reset the "Days in column" counter. Hope this helps!

Thanks!
Asad

alessandro_romolo_e

Dear Asad, thanks for your answer. When I set the status "Backlog" in "unmapped status" of my Kanban, all tickets disappear also from the backlog!
I should create another column called "Backlog" in my board, but that's not what I want.

Bill Sheboy

Hi @alessandro_romolo_e -- Welcome to the Atlassian Community!

For a company-managed project, the solution for this behavior is to have a separate status for the leftmost column of your board which is different from the backlog. For example:

Backlog
- status is "Backlog"
Board
- leftmost column status is "To Do", "Selected", or whatever works for your team
- ...other board columns

Kind regards,
Bill

Danut M _StonikByte_

Hi @alessandro_romolo_e,

Jira looks at the statuses mapped on the To Do column of the board. So, it you have a To Do status in workflow mapped on the To Do column of board, it will consider time in column the time since entrance in To Do status.

As @Bill Sheboy suggested, you should use different statuses like, for example, Backlog (for issues not added in sprint yet) and "To Do" for issues to be completed in the sprint.

Also, for counting the number of days in column, you could also try the WIP Aging Chart gadget offered by our Great Gadgets app.

It can calculate the age as time in column, time in current status, time since creation and lets you set a threshold to easily identify the ones that are taking too long already (the ones in red-color, above the red line). The age can be displayed in minutes, hours, or days.

In addition, can offers a more detailed report with time in column of each issue on board.

Danut

alessandro_romolo_e

Dear Bill, thank you for your answer.
Unfortunately I realise that my question is not clear, and I don't know how to make it more clear. I already have two different status, a status called "Backlog" and a status called "To do".

The problem is that, when I remove the status "Backlog" from the leftmost column, it also disappear from the visualisation of the backlog.

Bill Sheboy

Are you using a company-managed or a team-managed project? You may find that information in the list of projects, or at the bottom-left of the page expanding area.

Valeriia_Havrylenko_SaaSJet

Hi @alessandro_romolo_e 👋
If you're thinking about installing third-party add-ons, you might want to check out Time in Status

The Time in Status add-on lets you count the number of days in a column. You can easily view this information directly on the board by creating a custom field.

You can also book a live session to ask any questions about the add-on. Add-on developed by my team.

I hope you find this helpful 🚀

alessandro_romolo_e

It is a company-managed project, and I am an admin.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud