Proposal for "Time-In-Status" Monitor

[John Tucci]

I've asked the Community a question or two about this topic already, along with continuing my investigation through topical research. I've discovered Custom Fields for Issues, and I have formulated an approach that I'd like to sanity-check:

1. Create two custom fields in our Kanban board Issues:
   
   
   1. Status_Start: Time field to capture current date/time upon issue transition
   2. Status_Elapsed: Time field to hold computed time since "Status_Start"
2. Create two rules:
   1. On_Transition
      1. Capture current date/timestamp (via Now() JQL function)
      2. Reset Status_Elapsed field to "0"
   2. Daily (@EndOfDay/@StartOfDay)
      1. Compute "Time in Status" = Now() - "Status_Start"
      2. Generate notification if "Time in Status" > Predefined Threshold (x Days)
         1. Notification could be email to board admin(s)
         2. Question: Would like to have a visible indication within each Issue (Flag? Color?); is there a preferred method for this?