Okay, let's say I'm getting sporadic deliveries of something, approximately every 2-3 hours but sometimes 2 in quick succession, sometimes none for 8 hours, etc. Each time a delivery is made, the amount delivered is put in a document in elasticsearch.
Is it possible to create a graph that shows, over time, the sum of the amount of stuff delivered in the 24 hours previous to each point on the graph?
What if you create a visualization where the x-axis is a date histogram aggregation on the time field, with a daily interval. Then, set the y-axis to the sum of a given field. Would that give you what you're looking for?
But this shows me one datapoint per day, you can see it clearly when using a stepped line. What I want to see is not so much "sum per day", but a more granular view of how the sum over the past 24 hours changes throughout the day(s). I would like to be able to proactively identify periods of time like 2019-08-04 and 2019-08-05 (where sum dipped below 30) so I can take action. A graph with the current settings wouldn't show me a downward trend until that datapoint is registered on the graph for the day.
What I want to see is, instead of all time, it being cumulative only over a shifting window of about 24 hours previous to each data point, so the line would probably go up to and then hover around 30, at least in a view showing the past few weeks. Is that possible?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.