Maybe i didn't explain it good enough so i added a table where you can see what i mean.
As you can see the 5 min interval works. but 15 min interval does not, it had the same value as the 5 min interval at that time. What i want it to be is the total of those 5 min intervals.
Is this possible? Or do i have to make a very big 5 min interval and leave the rest out?
Timestamp | > | 5 Min Interval | 15 Min Interval | 15 Min i want |
1302679200 | > | 4.2929259482e+02 | | |
1302679500 | > | 2.5069977985e+00 | | |
1302679800 | > | 3.6908983814e+02 | 3.6908983814e+02 | 8.0088943076e+02 |
1302680100 | > | 8.0391143842e+03 | | |
1302680400 | > | 4.4017006223e+03 | | |
1302680700 | > | 4.7308772502e+02 | 4.7308772502e+02 | 1.2913902732e+04 |
1302681000 | > | 3.7983144383e+02 | | |
1302681300 | > | 1.5559865037e+00 | | |
1302681600 | > | 4.1231985070e+02 | 4.1231985070e+02 | 7.9370728103e+02 |