Average orders by product across all months

[mlombardi]

Hi! 

Im willing to calculate the avg numer of orders placed by article avg the hole year. 

So if each month I get 3 orders of that article, the KPI should show 3. 

The problem is that I have many orders and clearly non of them includes all articles. 

I need to somehow aggregate the formula by article and month to later calculate de anual average of orders placed by product

Thank you!!

[Vegar · Accepted solution]

If I understand you correctly then you should do something like this.

=avg(Aggr(Count(OrderID), Article, Month))