# Compare averages of multiple fields on one viz

**URL:** https://discuss.elastic.co/t/compare-averages-of-multiple-fields-on-one-viz/180859
**Category:** Kibana
**Created:** [May 13, 2019, 5:53pm UTC](https://discuss.elastic.co/t/compare-averages-of-multiple-fields-on-one-viz/180859 "2019-05-13T17:53:36Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Jeremy\_A](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jeremy_a/32/42598_2.png) [@Jeremy\_A](https://discuss.elastic.co/u/Jeremy_A)
#### Post date: [May 13, 2019, 5:53pm UTC](https://discuss.elastic.co/t/compare-averages-of-multiple-fields-on-one-viz/180859/1 "2019-05-13T17:53:36Z")

</div>

How can I create a visualization in Kibana that compares the averages of multiple fields on the same chart? I can do it easily in Timelion as a stacked bar graph for time-series data but in this case I don't want it to be time-based, I just want a vertical bar graph showing overall averages.

For example, let's say I have an index of customers, and for each customer there is a field for "NumberOfVisits" and "NumberOfSales". I want to have a chart where the x-axis is a series of different fields, and the y-axis is the average of each field.

Any recommendations?

If I were doing this in Excel I would just write out my list of fields in one column, and then in the next column have a series of calculated fields based on data pulled from each column of another sheet.

---

<div class="post-metadata">

### Author: ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)
#### Post date: [May 13, 2019, 7:47pm UTC](https://discuss.elastic.co/t/compare-averages-of-multiple-fields-on-one-viz/180859/2 "2019-05-13T19:47:02Z")

</div>

@Jeremy_A

You cannot do this kind of ad hoc math outside Timelion or the Timeseries visual builder.

This sort of thing might be possible with bucket scripts, but there is no support for this in Kibana Visualize just yet: see [https://github.com/elastic/kibana/issues/4707](https://github.com/elastic/kibana/issues/4707) for more info

---

<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: [June 10, 2019, 7:47pm UTC](https://discuss.elastic.co/t/compare-averages-of-multiple-fields-on-one-viz/180859/3 "2019-06-10T19:47:07Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.