Hello Gurus,
I am dealing with a table with metrics with some timestamps. We need to group the data every 15 or so minutes. Any ideas?
Thanks in advance!

-PVuppala

This message has been edited. Last edited by: vaayu,

Thank you BabakNYC, this looks like 8203 feature, unfortunately we're on 8201M. I'm tryinig using defines now.

  
DEFINE FILE MYFILE
START_INTERVAL/I4 = IF START_MINUTE LE 15 THEN 15 ELSE IF START_MINUTE FROM 16 TO 30 THEN 30 ELSE IF START_MINUTE FROM 31 TO 45 THEN 45 ELSE 60;
END

The problem with this approach is I need to make sure to fill the empty buckets i.e., for the rows that don't have a record I need to count as zeros. Hope it makes sense.

Maybe this can work for you?

START_INTERVAL/I4 = 
     IF {FIELD IN RECORD} EQ MISSING THEN 0
ELSE IF START_MINUTE LE 15 THEN 15 
ELSE IF START_MINUTE FROM 16 TO 30 THEN 30 
ELSE IF START_MINUTE FROM 31 TO 45 THEN 45 
ELSE 60;

Thanks for the ideas !! You guys rock!