CASE filter
My goal: When the "opened time" is checked to see if a call was responded to with in a 24 -48 hour period vs anything beyond 48 hours the desired results are not being returned..
I believe I'm getting hung up on what verbiage to use (contains?) in the case statement. I need to verify and assign this to the proper person.
Here's what I have currently: CASE SLA."RespTime, WHEN RespTime ,= 1 AND RespTime <= 2 THEN 'Yes' ELSE 'No'
Any suggestions would be appreciated.
Thanks