Report with 3 & 12 months rolling average and totals

Question

Hi,

Can someone help with creating a workflow with the output as a report with the 3 & 12 months rolling average and totals? I would really appreciate it if you could assist with the best way to present the report as I am still learning? Thanks in advance.

3 & 12 Months Avg with Totals.xlsx

IraWatt · Answer

Hey @SP3000,

The best place to go to learn about reporting on data in Alteryx is the interactive learning videos on the community, check out Interactive Lessons - Alteryx Community Reporting.

SP3000 · Answer

Thank you so much Ira! It's very helpful. And i am also trying to learn how to present this kind of data in a report. So I am looking for a better way to use the reporting operators to provide some insights into the data. I truly appreciate your kind help..

IraWatt · Answer

Hey @SP3000,

You can create 12&3 month averages using the multi row formula tool to average multiple rows. I created the total for each category using the summarize tool and added it in at the bottom of each category:

Any questions or issues please ask :)
HTH!
Ira

1906.yxmd