community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Is there a way to create running averages?

Meteor

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.

Alteryx Certified Partner

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

Highlighted
Bolide

This is how I would do it....

 

Sort the data

Use a multi-row tool to create a running total

Use a record id to give you the row # (you could also use a multi row tool to create a custom row #)

Use the running total and divide it by the record id

 

Take a look at the attached example

Meteor

adm510,

 

Thank you so much for that. That perfectly answers what I was looking for!

 

Labels