Need the duration of column in days instead of dots

[Nagarjuna Busireddypally]

Instead of dots on boards we need to see the number of days.

If that is not possible, can anyone help in creating a field calculation through automation to show how many days issue in each status so that we can add that field to cards.

[Bill Sheboy]

Hi @Nagarjuna Busireddypally 

The "days in column" feature only shows the dots; when you hover over them, the day count is shown.

Next...if you regularly improve your workflow/board layout, that is not tracked well in Jira.  You may have trouble managing those measures in that case.

The built-in Atlassian interpretation of a "control chart" also has this information, although it has its limitations.  You can also approximate what you ask by adding some quick filters with thresholds (e.g., more than 2d, more than 5d, etc.) if that is your concern.

If you have a complex workflow/board layout, an marketplace addon for reporting or a dashboard gadget may be better to see the days in column as a number...rather than seeing them on the Jira board.

If you have a simpler workflow/board layout, you can do this with automation rules, with some assumptions/constraints:

• The simple case assumes you do not go backwards in flow.  If you do, the solution is more complicated.
• For each column, you will need custom fields (or entity properties) for start date/time and end date/time, and for the time in status value
• The rule would set the start on entering a status and the end on leaving the column
• On exit, you could perform the math using the date/time difference functions.  Ensure you convert your date/time values to your time zone before the math operation.  Also decide in advance if you want working days or calendar days.
• You also need to decide what to do if a person manually edits any of these fields.  This limitation is why people sometimes use an approach which always reads from the issue history, rather than using custom fields.

Kind regards,
Bill

[Trudy Claspill]

Hello @Nagarjuna Busireddypally 

It is not possible to display the "Days in Column" dots as a number of days.

For your automation do you need to only track how long an issue has been in its current status, or do you need to keep track of how long it was in each status?

If the issue can go to status A, then to status B, then back to status A, would you reset to zero the time spent in status A or add to the previous total?

How much experience do you have with the Automation feature? What types of rules have you constructed? Have you attempted to construct any rules for this requirement?