You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Multiple Expressions in 1 Definition - Same Day Resolution

edited Jul 5, 2017 11:54PM in Reporting & Analytics for B2C Service 3 comments

Content

Hello all, 

Looking for some assistance and I am stumped. I want to build report definition that tells me if the incident was created and closed in the same day for that agent. It is possible for transactions.trans_type=4 (assigned) and transactions.id1=2 (closed) have more than 1 date, would need to use min / max. I am just not sure how to create multiple expressions.

me to documentation that explains how to build a definition as an expression of 2 other columns in the report like in excel? E.g =if(AND(A1=4,B1=3),1,2)

 

Any help would be great, thank you!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!