ElasticSearch and Kibana: compare value with aggregated value

I'm wondering how to accomplish this requirement. I have to compare value
data with the average over the selected period or over another period.

I've collected millions of records in an index. These records contains the
sellout amount day by day for different vendors, products, sectors and
product families.

What I'd like to do is to analyse any single value with the average of the
selected period or the average of the same periodo of a previous year. I'd
like to use Kibana to show data to users.

How can I accomplish it?

Thanks

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/722ca640-e1bd-4617-9a5e-efa23103d5d9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.