Here is an example of the data that I'm ingesting. I did have to take irrelevant data out because of confidentiality reasons.
{
end: 2019-07-18 14:59:51.904915
start: 2019-07-18 14:59:47.734263
exampleInteger: 417
}
So I am given a start/end timestamp. I have successfully create a line graph (it graphs on on the end timestamp as the x axis) that plots a count of all the events every hour. For example, between 2019-07-18 14:00:00.000000 AND 2019-07-18 14:59:59.999999, I got a count of 7394. I want to take that 7394, along with 23 other counts throughout (because there are 24 hours in a day), and average them. For example:
2019-07-18 00:00:00.000000 AND 2019-07-18 00:59:59.999999 COUNT: 7394
2019-07-18 01:00:00.000000 AND 2019-07-18 01:59:59.999999 COUNT: 8053
2019-07-18 02:00:00.000000 AND 2019-07-18 02:59:59.999999 COUNT: 7265
2019-07-18 03:00:00.000000 AND 2019-07-18 03:59:59.999999 COUNT: 7237
2019-07-18 04:00:00.000000 AND 2019-07-18 04:59:59.999999 COUNT: 7656
2019-07-18 05:00:00.000000 AND 2019-07-18 05:59:59.999999 COUNT: 7528
2019-07-18 06:00:00.000000 AND 2019-07-18 06:59:59.999999 COUNT: 7948
2019-07-18 07:00:00.000000 AND 2019-07-18 07:59:59.999999 COUNT: 7254
2019-07-18 08:00:00.000000 AND 2019-07-18 08:59:59.999999 COUNT: 7744
2019-07-18 09:00:00.000000 AND 2019-07-18 09:59:59.999999 COUNT: 7752
2019-07-18 10:00:00.000000 AND 2019-07-18 10:59:59.999999 COUNT: 7936
2019-07-18 11:00:00.000000 AND 2019-07-18 11:59:59.999999 COUNT: 7410
2019-07-18 12:00:00.000000 AND 2019-07-18 12:59:59.999999 COUNT: 7047
2019-07-18 13:00:00.000000 AND 2019-07-18 13:59:59.999999 COUNT: 7008
2019-07-18 14:00:00.000000 AND 2019-07-18 14:59:59.999999 COUNT: 7394
2019-07-18 15:00:00.000000 AND 2019-07-18 15:59:59.999999 COUNT: 7647
2019-07-18 16:00:00.000000 AND 2019-07-18 16:59:59.999999 COUNT: 7954
2019-07-18 17:00:00.000000 AND 2019-07-18 17:59:59.999999 COUNT: 7541
2019-07-18 18:00:00.000000 AND 2019-07-18 18:59:59.999999 COUNT: 7145
2019-07-18 19:00:00.000000 AND 2019-07-18 19:59:59.999999 COUNT: 7421
2019-07-18 20:00:00.000000 AND 2019-07-18 20:59:59.999999 COUNT: 7045
2019-07-18 21:00:00.000000 AND 2019-07-18 21:59:59.999999 COUNT: 7453
2019-07-18 22:00:00.000000 AND 2019-07-18 22:59:59.999999 COUNT: 7155
2019-07-18 23:00:00.000000 AND 2019-07-18 23:59:59.999999 COUNT: 7124
The average of this 24 hour period would be 7462
I need a line graph that shows the past months worth of data. On this graph, I have to lines: the first lines is the hour per hour count and the other is the 24 hour average of those hour per hour counts.
I hope I might that clear... I know it's a lot of information. Thank you.
... View more