if statement with time stamp

[rdsuperlike]

I have defined a field as below in my script:

timestamp(max_time,'hh:mm:ss') as "Status%max_time",

i want to write if condition with max_time categorized  as <5 mins, >=5 mins to <=20 mins and >20 mins. Not sure how to categorize this timestamp value. Can someone help?

eventually want to create charts with above 3 categories with various dimensions

Thanks in advance

[kaushiknsolanki]

Hi,

You should create a new field as minute and then use that field for conditioning.

Load Minute(max_time) as minutes

From xyz;

Regards,

Kaushik Solanki