Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Combining Expressions using AND OR statements — Cloud Customer Connect
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

Combining Expressions using AND OR statements

Accepted answer
11
Views
2
Comments
edited Oct 8, 2015 3:06PM in Reporting & Analytics for B2C Service 2 comments

Content

I am hoping someone can assist me. I created a report (definition attached).

I am wondering how I could combine the Update and New columns together.

For example:

Column 1 (sums how many updated incidents are more than 10 hours old since the time it was updated)

sum(if(incidents.status_id=8 & date_diff(sysdate(), incidents.updated)<3600*$sl10, 1,0))

 

Column 2 (sums how many new incidents are more than 10 hours old since the time it was created)

sum(if(incidents.status_id=1 & date_diff(sysdate(), incidents.created)<3600*$sl10, 1,0))

 

I would like to combine these two into one column to show how many updated or new incidents are more than 10 hours old from the time created or updated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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