# Is it possible to display "Average amount" in X axis?

**URL:** <https://discuss.elastic.co/t/is-it-possible-to-display-average-amount-in-x-axis/43705>\
**Category:** Kibana\
**Created:** [March 7, 2016, 8:54pm UTC](https://discuss.elastic.co/t/is-it-possible-to-display-average-amount-in-x-axis/43705 "2016-03-07T20:54:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![MRamakri](https://avatars.discourse-cdn.com/v4/letter/m/bcef8e/32.png) [@MRamakri](https://discuss.elastic.co/u/MRamakri)\
**Post date:** [March 7, 2016, 8:54pm UTC](https://discuss.elastic.co/t/is-it-possible-to-display-average-amount-in-x-axis/43705/1 "2016-03-07T20:54:53Z")

</div>

I'm trying to create a bubble chart with "Average item price" in Y axis, and "Average basket price" in X axis. I can create "Average item price" in Y axis without any problems. However, I only see Histogram as an option for X axis to display custom X axis, and it only lets me use the actual field values. Is it possible to use any aggregations on the X axis like sum, average, mean, etc.?

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [March 8, 2016, 12:45am UTC](https://discuss.elastic.co/t/is-it-possible-to-display-average-amount-in-x-axis/43705/2 "2016-03-08T00:45:19Z")

</div>

Not with any of the existing visualizations in Kibana, they all use bucketing data (aggregations) for the x-axis.

You might be able to get a close approximation of the tends you're looking for with the Histogram though. For example, if you were to bucket on the total basket price for the x-axis and use the average item price as the metric on the y-axis, you might get an idea of if it were a few number of expensive items or a large number of cheap items driving large orders. I'm not entirely sure that would work though, or if that's even the information you want.

---

<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:59pm UTC](https://discuss.elastic.co/t/is-it-possible-to-display-average-amount-in-x-axis/43705/3 "2017-07-06T13:59:56Z")

</div>


