Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

moving average without multi-row-formula Tool

SaoriYamguchi
8 - Asteroid

I would like to get a moving average like the sample data.
In addition, the average you want to use is calculated using small numbers such as 1 and 2 to large numbers such as 100 and 200.

The multi-low formula can only run + -3 lines on average, so I'd like to know how to do that.
Also, I want to average a large number of data in multiple lines like attached data, so please tell me how to do that.

Thank you very much

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @SaoriYamguchi ,

 

Nice challenge.

Take a look and let me know if this works for you. I've tried to describe every step to make it clear what I've done.

 

fmvizcaino_0-1614828543471.png

 

 

Best,

Fernando Vizcaino

Qiu
19 - Altair
19 - Altair

@SaoriYamguchi 
Try to make it a bit dynamic.

So you need to define the moving average number (How many rows) as input, then macro would do the rest.

But if you want exactly the same as your Excel, we need think more.

0304-SaoriYamguchi-1.PNG0304-SaoriYamguchi-2.PNG

SaoriYamguchi
8 - Asteroid

@fmvizcaino @Qiu 

Thanks!

 

Qiu
19 - Altair
19 - Altair

@SaoriYamguchi 

Glad to help and thank you for the accept mark.

Labels