# Calculating variance using kibana

**URL:** <https://discuss.elastic.co/t/calculating-variance-using-kibana/59831>\
**Category:** Kibana\
**Created:** [September 5, 2016, 4:48pm UTC](https://discuss.elastic.co/t/calculating-variance-using-kibana/59831 "2016-09-05T16:48:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![noob](https://avatars.discourse-cdn.com/v4/letter/n/5e9695/32.png) [@noob](https://discuss.elastic.co/u/noob)\
**Post date:** [September 5, 2016, 4:48pm UTC](https://discuss.elastic.co/t/calculating-variance-using-kibana/59831/1 "2016-09-05T16:48:14Z")

</div>

Want to calculate variance for a time series data of multiple restaurants with number of customers visiting every day.

```
date name numCustomers
1-Sep-2016 restaurant1 40
2-Sep-2016 restaurant1 30
3-Sep-2016 restaurant1 35
--------------------------
1-Sep-2016 restaurant2 20
2-Sep-2016 restaurant2 24
--------------------------
1-Sep-2016 restaurant3 50
3-Sep-2016 restaurant3 45

```

For a each week, want to find variance in number of customers visiting each restaurant.

i.e. want to first bucketize the data per week. Then sum numCustomers for each restaurant and find variance on calculated sum. For above example need to find variance for [restaurant1(40+30+35), restaurant2(20+24), restaurant3(50+45)]

Looked at [extended stats aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-metrics-extendedstats-aggregation.html) but not sure how this can be utilized here.

---

<div class="post-metadata">

**Author:** ![bevacqua](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bevacqua/32/10312_2.png) [@bevacqua](https://discuss.elastic.co/u/bevacqua)\
**Post date:** [September 5, 2016, 9:00pm UTC](https://discuss.elastic.co/t/calculating-variance-using-kibana/59831/2 "2016-09-05T21:00:48Z")

</div>

You could use Pipeline Aggregations for this computation.

[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline.html)

This has to be done in Elasticsearch, though, and support for Pipeline Aggregations in Kibana is still forthcoming.

> <https://github.com/elastic/kibana/issues/4584>

---

<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, 1:39pm UTC](https://discuss.elastic.co/t/calculating-variance-using-kibana/59831/3 "2017-07-06T13:39:30Z")

</div>