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

How to write a custom script to update a column in a report based on all values in another column

edited Apr 25, 2017 11:26AM in Reporting & Analytics for B2C Service 3 comments

Content

Hello

I have used the following expression (rel_date_diff(time_billed.bill_date, incidents.created, 1) through response requirements to confirm how long it took for emails to be completed.

Rather than have a large line by line I need to nest the expression to give me a count within Service and outside of Service. For example if the answer ( in seconds format is less than 345600 then "Within SLA", if Greater than 345600 then "Outside of SLA"

Unfortunately the expression cannot be nested so I have to use a custom script.

The expression is in column 5 (called 'Response SLA". I want column 6 ('Response SLA in Seconds') to update with 'Inside SLA' or 'Outside of SLA'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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