June 13, 2013
How many working hours since my item was created?
Tracking the time since an item was created can be important, but how do you take working hours and weekends into account? You need to make sure you are giving most attention to the items that most need it. Often this means that you want to be able to give particular attention to items that are late or will soon be late. For example a defect that has been open for too long or a help desk issue that has not been addressed within its SLA. Many customers I talk to address this in TestTrack by creating reports, filters, and escalation-type automation rules based on the "Date Created". These provide reports and automated email notification when items have exceeded a certain length of time without the appropriate action being taken. This is great but one issue is how to deal with working hours and weekends. For example, if you want to ensure an item cannot be in an open state for more than 16 hours without being assigned, you might want to be emailed when an item is open for 15 hours. That's fine, but how do you deal with an item raised on Friday afternoon? Come Monday morning you will get an email for every Friday afternoon item even though they are not really late. You have a similar problem for the working day when items are raised close to 5pm. This issue was tricky to deal with in the past but now, using TestTrack's new calculated fields functionality, you can take into account your working hours and weekends.
Calculated Fields ExampleThis example has two custom fields: "Working hours since creation" and "SLA status".
- The "working hours since creation" field is the number of hours since the "date created" time but only includes time between 9:00 and 17:00 (the time I have designated working hours) and does not include weekends.
- The "SLA status" field is either OK (< 60 hours), close to overdue(<240), or Overdue (> 240 hours) depending on how long since an item was created.