adjust the [Days in Column]

[Shiva]

Hi,

[Days in column] is a default calculated column in our Kanban Board.

i have a existing automation. What i want is, that it should reduce [Days in Column] to ZERO when it runs.

Is this possible? i cannot find the field [Days in Column] when trying to create a automation. So that means i need to implement i manually. probably like:

{
"fields": {
"Days In Column": 0
}
}

it this correct?

[Bill Sheboy]

Hi @Shiva Ajodhia 

Would you please clarify what problem you are trying to solve?

It would appear you have a custom field called "Days in Column"...or...are you referring to the built-in "Days in column" setting for a board showing the dots for time indication: 

Show a visual indicator on each card that represents the time spent in the column. This can help identify slow moving issues.

Kind regards,
Bill

[Shiva]

@Bill Sheboy- im referring to the built-in "Days in column" setting for a board showing the dots for time indication.

Trudy mentioned she already checked if its possible to reset it, but it did not work. thats unfortunate.. but at least i have a answer to work with

[Bill Sheboy]

Thanks for that information. 

Other than teams using a simple workflow (with no moving backwards in flow), we often ignore that feature.  Instead we use an actual Age Of WIP custom field set with automation.  That seems more valuable than knowing the time in a board column which may contain multiple, mapped status values.  When we need actual "time in status" for cycle time calculations we use the Atlassian interpretation of a "control chart" or marketplace addons for reporting.

[Trudy Claspill]

Days In Column is not an editable field. The information is derived in real time and presented on the board.

I was going to suggest that you could reset its value by moving it to another column and then back to the original column, but I just tested that and it does not actually reset the value.

[Jeret Shuck]

> moving it to another column and then back to the original column, but I just tested that and it does not actually reset the value.

This. This is exactly what I was hoping this feature did. I'd like that value reset to zero, once it's moved into a new column.