# ElasticSearch and Kibana: compare value with aggregated value

**URL:** <https://discuss.elastic.co/t/elasticsearch-and-kibana-compare-value-with-aggregated-value/23150>\
**Category:** Elasticsearch\
**Created:** [April 8, 2015, 1:45pm UTC](https://discuss.elastic.co/t/elasticsearch-and-kibana-compare-value-with-aggregated-value/23150 "2015-04-08T13:45:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![diegoatos](https://avatars.discourse-cdn.com/v4/letter/d/3e96dc/32.png) [@diegoatos](https://discuss.elastic.co/u/diegoatos)\
**Post date:** [April 8, 2015, 1:45pm UTC](https://discuss.elastic.co/t/elasticsearch-and-kibana-compare-value-with-aggregated-value/23150/1 "2015-04-08T13:45:20Z")

</div>

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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/722ca640-e1bd-4617-9a5e-efa23103d5d9%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 12:20am UTC](https://discuss.elastic.co/t/elasticsearch-and-kibana-compare-value-with-aggregated-value/23150/2 "2017-07-06T00:20:52Z")

</div>