I also tried to do a CASE statement where the modified date is greater than the audit date but it comes up blank. I'm really stuck on this. Does anyone know how to solve How long a ticket sits before the next edit is done. For example
John gets assigned a ticket on 5/10 he marks it as pending 5/11 - so it sat for 1 day before he did anything
Jane gets assigned a ticket on 5/10 and makes a comment on 5/12 - so it sat for 2 days before she did anything.
Somehow I need to figure out after a ticket is assigned how long did it sit before the person did ANYTHING to the ticket (assigned it out to someone else, a comment, status changes, notes, etc).
Any help or direction would be appreciated.