I am trying to create an average count where I have specific date spreads.
For now I have 3 relevant columns:
1 column has 4 different string options, for example, fruits: [apples, oranges, pears, bananas]
another is a start of hour tracker for said data,
and another is a data pulled timer, where data is pulled every 5 minutes.
So for an example table, you could have:
| Fruits | StartOfHour | DataPulledTime |
| apple | 2019-06-03 10:00:00 AM | 2019-06-03 10:00:00 AM |
| orange | 2019-06-03 10:00:00 AM | 2019-06-03 10:05:00 AM |
| orange | 2019-06-03 10:00:00 AM | 2019-06-03 10:10:00 AM |
| banana | 2019-06-03 10:00:00 AM | 2019-06-03 10:05:00 AM |
| banana | 2019-06-03 10:00:00 AM | 2019-06-03 10:10:00 AM |
| banana | 2019-06-03 10:00:00 AM | 2019-06-03 10:10:00 AM |
What I want to make is a bar graph that shows in hourly chunks, the average number of fruits. So for this piece of data, the expected outcome for the 10am hourly chunk would be:
.083 apples (only 1 apple was eaten in 12 update cycles, meaning you only have on average 1/12th of an apple)
.16 oranges (1 orange eaten for 2 of the 5 minute cycles, none for the rest, so the average is .16)
.25 bananas(1 banana eaten 1 cycle, 2 eaten 1, and none the rest.)
Anyone have a good idea on how to implement this?
