How to group mins into time interval

[#1]

For the time column

24

201

11

43

21

57

0

121

22

4

159

0

2

46

Need to group them into Time interval:

15 - 120min

120 - 240min

240 - 360min

each interval is 120min

[nagarjuna_kotha]

Hi Wil,

If your range is same for all the time ,You can also use class function.

Try this:

Class(FieldName,120)

its gives you 120 range

-Nagarjuna

[nagarjuna_kotha]

Hi Try to use class functon

It might solve your issue.

[nagarjuna_kotha]

Like this ?

PFA

[nagarjuna_kotha]

there you have to observe two things.

1.3rd column it is showing two 107 val right accoding to this value the range will show.

2.You have two airlines for same record ,thats the reason it is showing

-Nagarjna

[MarcoWedel]

Hi,

please close your thread if your initial question regarding interval groups is answered and open a new thread for your aggregation questions. A sample application might help to understand your data model and aggregation issues.

thanks

regards

Marco