I have an issue about the avg mathematical operation in elasticsearch.
In the singlestat panel , I want to get average download count per day so the interval is set to 1d and options-value-stat is set to “avg”.
When I set timerange to “yesterday”,it shows 1.24Mil, but in fact the total download is 2.49Mil, so the avg shoud be 2.49Mil but only half.
Next,when I set timerange to “last 7 days”,we can get total count from graph panel is 28.16Mil, 28.16/7=4.02Mil/day , but it shows 3.52Mil/day as 28.16/8. the graph panel(interval is also set to 1d) and singlestat panel avg value both incorrect.
why does the days plus 1 when I calculate the average？this is my question
I’m not sure if I have a clear statement wish for your reply