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

Simple questions of IF/ELSE statements

Accepted answer
30
Views
2
Comments
edited Aug 9, 2018 9:14AM in Reporting & Analytics for B2C Service 2 comments

Content

I have a variable as follows in a report:

date_diff(incidents.closed,incidents.created)/1

I have a column defined as the following:

if($t <= 604800,1,if($t <= 1209600,2,if($t <= 1814400,3,if($t <= 2419200,4,if($t <= 3024000,5,if($t <= 3628800,6,if($t <= 4233600,7,if($t <= 4838400,8,if($t <= 5443200,9,if($t <= 6048000,10,if($t <= 6652800,11,if($t <= 7257600,12,if($t <= 7862400,13,14)))))))))))))

Am I right in thinking for less than 1209600, it won't include anything less than 604800 or will it include that as well?

Second part of the question is that I want to see *everything* under a particular amount. If my assumption above is correct, how would I go about this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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