timestamp / count in location 1 / count in location 2
e.g. rows:
15:05 / 22 / 12
15:32 / 21 / 10
15:44 / 20 / 9
17:30 / 10 / 8
What I'm trying to do is plot a graph that shows each 1/2 hour time slot on the X axis (can i configure how long each slot is?) between say, 7am and 9pm (once again, don't mind 24 hours!), with the lines on the chart showing the average count during that period.
so e.g. in this case on x axis i'd like 15:00 - 15:30, with the y axis valud being 21.5 for location 1 and 11 for location 2; showing no lines for the rest of the containers, and then having the 17:30-18:00 container having 10 in location 1 and 8 in location 2.
Quite complex given it needs to average?
Any ideas how to go about doing this?
Thanks!
e.g. rows:
15:05 / 22 / 12
15:32 / 21 / 10
15:44 / 20 / 9
17:30 / 10 / 8
What I'm trying to do is plot a graph that shows each 1/2 hour time slot on the X axis (can i configure how long each slot is?) between say, 7am and 9pm (once again, don't mind 24 hours!), with the lines on the chart showing the average count during that period.
so e.g. in this case on x axis i'd like 15:00 - 15:30, with the y axis valud being 21.5 for location 1 and 11 for location 2; showing no lines for the rest of the containers, and then having the 17:30-18:00 container having 10 in location 1 and 8 in location 2.
Quite complex given it needs to average?
Any ideas how to go about doing this?
Thanks!