Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Combine a custom Yes/No field to an existing Exception Expression

edited Dec 9, 2016 12:23PM in Reporting & Analytics for B2C Service 1 comment

Content

Hello,

Currently in several of our reports related to incident, we have an Exception that changes the type of a row in the report if the incident has been Escalated by business rules:

if((incidents.escllevel=6 | incidents.escllevel=2 | incidents.escllevel=3) & incidents.status_type <>2 & incidents.c$response_sent_2=0, 1, 0 & orgs.c$enterprise_org='No', 'Yes') -> equals 1

 As we also have two group of SLA (Normal and Enterprise), we also have a seperate exception to mark out incidents with an Enterprise SLA based on a custom field:

orgs.c$enterprise_org equals 'Yes'

The orgs.c$enterprise_org is a Yes/No field.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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