time bands

[#1]

HI,

I have data with Date&Time field and corresponding Visits to it. I would like to plot a graph showing 30min trend.

e.g.

Time                         Visits

0600	1,004
0630	1,403
0700	1,987
0730	2,916
0800	3,063
0830	4,875
0900	6,356
0930	7,415
1000	6,454
1030	6,786
1100	8,298
1130	8,276
1200	9,074
1230	10,341

How can I agregate data on every 30min?

Any idea please?

Thanks

[Gysbert_Wassenaar · Accepted solution]

This discussion might help you

[#3]

It works thanks a lot.