How to get monthly average sales per product?

[Anonymous]

Hi everyone,

I'm creating a chart which displays the monthly average sales per product however I have a daily data set in Excel.

In the Expressions tab, I used this expression: =Avg(Aggr(Sum(Sales),Date,Product)) and upon applying, chart looked like this

The scale was a lot smaller since I have data set in daily format but what I need is the monthly averages.

I've also tried editing the Script using the MonthStart string to no avail. Hope someone can help me on this.

Thanks!

[sunny_talwar · Accepted solution]

Have you tried this?

=Avg(Aggr(Sum(Sales),MonthYear,Product))

Where MonthYear is calculated in the script like this

Date(MonthStart(Date), 'MMM-YYYY') as MonthYear

[Anonymous]

I did it! Thanks for the help!