Row Average Calculation

Question

I have below Data

ItemDateSalesChair01/01/2024100Chair02/01/2024200Chair03/01/2024300Chair04/01/2024200Chair05/01/2024200Chair06/01/2024200

I need to calculate daily sales average like output below,.

ItemDateSalesSales AvgChair01/01/2024100100Chair02/01/2024200150Chair03/01/2024300200Chair04/01/2024200200Chair05/01/2024200200Chair06/01/2024200200

I'm wondering which macro does this for me, can some one help?

davidskaife · Answer

Hi @Alteryxexpert

Not as it stands, i've attached a revised workflow and added in a Formula tool to generate Month/Year column, and added that is as a Group By criteria for the Multi-Row Formula tools.

Row Average.yxmd

Qiu · Answer

@Alteryxexpert 
I found this post and it should help.
https://www.thedataschool.co.uk/jeremy-kneebone/calculating-moving-average-alteryx/

flying008 · Answer

Hi, @Alteryxexpert

FYI.

ItemDateSalesSales AvgChair01/01/2024100100Chair02/01/2024200150Chair03/01/2024300200Chair04/02/2024200200Chair05/02/2024200200Chair06/02/2024200200