Question about a table field

[ShellyG]

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! 

[martinpohl · Accepted solution]

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

[ShellyG]

Thanks a lot!