Hello,
I know I can do a running total on fields, but is there a way to do a running average? I was thinking that maybe using an iterative macro would work. I am new to Alteryx, and loving it, but I still have so much to learn.
I did see the Running Averages Challenge, but is seems to me that you need to know the number of rows you are going to have prior to creating that. I could certainly be misunderstanding the solutions I saw.
Thank you.
Solved! Go to Solution.
Hey
I guess it depends (I am a consultant after all !) on what you want, but we have used several Multi Row formula tools for this.
Set a "marker" field to keep track of your grouping column, then you can refer to this in an iterative way to fill down the rows that you want to average together.
Then group by this and calculate average.
It would help if you posted the source dataset and the desired outcome.
Cheers
adm510,
Thank you so much for that. That perfectly answers what I was looking for!