Hi guys,

I am making a Dashboard where I want to show the AOV per Brand with a date filter to change the days used in the calculation.

AOV = sales / orders

I have sales and orders per day and would like to have the AOV dependant on the Days selected.

The only way I found to display the AOV is to calculate it per day and then put an avg() over it in the widget, but this doesn´t show the the true number (avg of avg). Ideally it would be sth similar to what you can do in excel with pivot calulated fields.

I am using sql