How to write a custom script to update a column in a report based on all values in another column
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'
Tagged:
0