Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This discussion might help you
It works thanks a lot.