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:
Thanks in advance!