# Barplot of aggregation on result of aggregation

**URL:** <https://discuss.elastic.co/t/barplot-of-aggregation-on-result-of-aggregation/133916>\
**Category:** Kibana\
**Created:** [May 30, 2018, 4:33pm UTC](https://discuss.elastic.co/t/barplot-of-aggregation-on-result-of-aggregation/133916 "2018-05-30T16:33:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![denismaciel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/denismaciel/32/31555_2.png) [@denismaciel](https://discuss.elastic.co/u/denismaciel)\
**Post date:** [May 30, 2018, 4:33pm UTC](https://discuss.elastic.co/t/barplot-of-aggregation-on-result-of-aggregation/133916/1 "2018-05-30T16:33:44Z")

</div>

I have the following documents in Elasticsearch. Each document represents an order from a user of an e-commerce shop. Each document has the items that were bought (in an array) together with the user id.

**I want to calculate the average number of items per order for each user, count how many users have X orders and then plot it in a bar plot or a histogram**.

More details below:

```json
{
"user_id": 1,
"bought_items" : ["Ball", "Pen"]
},
{
"user_id": 2,
"bought_items" : ["SomeItem1", "SomeItem2", "SomeItem3", "SomeItem4"]
},
{
"user_id": 1,
"bought_items" : ["Car", "Motorcycle", "Truck", "Yacht"]
},
{
"user_id": 3,
"bought_items": ["Iterm1", "Item2", "Item3"]
}

```

First, I want to per user get the average items in an order. Here:

user 1 =\> 3  
user 2 =\> 4  
user 3 =\> 3

And then make a bar plot (or a histogram) where the bars represents how many users have on average bought X items. Here it would be:

2 users have bought 3 items on average.  
1 user has bought 4 items on average.

I imagine the result of the query would look like something like this:

```json
[{
"item_quantity": 3,
"count" : 2
},
{
"item_quantity": 4,
"count" : 
}]

```

How could I accomplish that?

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [May 30, 2018, 5:06pm UTC](https://discuss.elastic.co/t/barplot-of-aggregation-on-result-of-aggregation/133916/2 "2018-05-30T17:06:47Z")

</div>

Arrays don't work well with Kibana's visualization abilities. If you want to do something like that you'd first have to also index `item_count` in each document.

Even then, I'm not sure this will really work how you want, because the average items in an order isn't discrete, like you've suggested. For example, if user 1 had only three items in the second order, then their average items in an order would be 2.5. Would you be wanting to plot that as part of item\_quantity 2 or 3? Or separately?

The closest you can probably get is to have a metric that shows you the overall average of average order size per user. To do this, you would use an "average bucket" aggregation where you bucket by "terms for user\_id" and select as the metric the "average item\_count".

---

<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 27, 2018, 5:06pm UTC](https://discuss.elastic.co/t/barplot-of-aggregation-on-result-of-aggregation/133916/3 "2018-06-27T17:06:48Z")

</div>

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