Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
I did it! Thanks for the help!