Conditional DATEDIFF
I have a query that returns the number of business days between two dates for a ticketing system. I'm trying to determine average resolution times for our support tickets and have a beast mode that works for the total number of business days between case open and case resolved. CASE DATEDIFF(`Resolved Date`, `Case Creation…
