Making stories visible when they're taking a long time

[Jovanna Pugh]

Does anyone know if there's a way in Jira to highlight cards that are taking longer than an expected amount of time?  We have the `Days in Column` feature turned on, but we feel that it's not obvious enough.  Is there anything to make the background of the card turn red or something else a little more apparent than just the dots on the card?

[Kurt Klinner · Accepted solution]

@Jovanna Pugh 

Hi Jovanna

is is possible to customize the coloring of cards by making use of JQL queries

https://confluence.atlassian.com/jirasoftwareserver0713/customizing-cards-965542346.html

e.g. 

updated >= -16h

Cheers

Kurt

[Jovanna Pugh]

Thank you!  Do you know if it's possible to exclude weekends from that count?

[Kurt Klinner]

Not sure if that is possible, but i was just thinking if you could for example

check the workratio field in the JQL workRatio = (timeSpent / originalEstimate) x 100, so if you have spent more time on the ticket than original estimate the ratio would show that

https://confluence.atlassian.com/jiracoreserver073/advanced-searching-fields-reference-861257219.html

Cheers

Kurt

P.S. To get that working time tracking needs to be enabled at your instance

[Jovanna Pugh]

Thanks!  I created a query that turns cards red if they've been in a certain status for more than 5 days:  

project = TR AND issuetype in (Bug, Story) AND status in ("Being Developed", "Blocked", "In PR") AND cf[11007] = Web AND !(status changed after -5d)

Nice to haves now:

• Don't count weekends
• Do count the total of time in each status, not just upon each status change.  For example, a card that was Being Developed for 3 days, moved to In PR, then back to Being Developed for 3 more days would turn red because the total time in Being Developed is greater than 5 days.