I have a document with two fields, timestamp (date) and response_time
Now suppose I want to do a query like 'Get the daily average response time
for each day of the last 10 days', what's the recommended way to do this?
If I want to use the Statistical facet, then I will have to fire the same
query (changing date range in the filter each time) 10 times. Is there a
way this could be done in a single query?
Basically I want to do a date range facet on the timestamp field, and for
each daily bucket I want to calculate the statistical function (like mean,
max, distinct etc)