I've evaluating Elasticsearch/Kibana for our specifics. I've a requirement where we are putting hourly reports data in elasticsearch and want to visualize say daily averages for last week. It requires multi level aggregation where we first need to aggregate (sum) hourly data into daily buckets and then take the average over last week data.
I could not find a way to do it through Kibana. It seems to be supporting only one level of aggregation. Would appreciate any help.