How to visualise average bucket aggregation with visual builder?

Elastic Stack Kibana
1

Hi! I have data for an e-shop. Basically orders with order entries. I would like to visualise the average quantity per order over time. My index is something like:

order_entries:
  - order_date
  - order_id
  - quantity

So basically i want to sum all quantities of entries with the same order_id and then make an average (by day). I managed to do it with the simple line chart, but i would like to know how to make it in visual builder too, if possible. The line chart's configuration is:

image
image.png891×983 38.6 KB

image

Thanks in advance!
Bogdan

2

It's not very elegant, but this gave me roughly the same kind of data over time:

image
image.png2828×1134 132 KB

image
image.png2108×380 37.3 KB

3

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