Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
Can someone give me an advise what to do in the following situation:
I have a field that shows how fast a ticket was resolved. So basically this field contains - "same day", "more than 2 days", "more than a week", "more than a month", etc.
I need to visualize this by only showing - "same day" and "not the same day".
How can I do that on a script level while also keeping the field in its original state?
Thanks!
so load your field as a second one
load
yourfields,
if(solved='same day',same day','not the same day')) as Newsolved
from Yoursource;
Regards
so load your field as a second one
load
yourfields,
if(solved='same day',same day','not the same day')) as Newsolved
from Yoursource;
Regards
Thanks a lot!