How to visualise average bucket aggregation with visual builder?

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_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:


Thanks in advance!

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

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