Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Data Imputation

Raj
16 - Nebula

I have data where i want to replace the blank with average of next 5 values

and the filling should start with bigger values first such as it should first fill for 2002 then 2001 and then 2000 so it considers new values as well in the calculation

 

for eg as 2000 is blank it should take average of new 2001, new 2002,, 2003, 2004 and 2005 

 

Year Price
2000
2001
2002
2003 68
2004 73
2005 74
2006 50
2007 51
2008 52
2009 59
2010 64
2011 89
2012 60
2013 71
2014 60

 

thanks in advance

2 REPLIES 2
ed_hayter
12 - Quasar

I reordered the data and imputed with a multi-row formula - i reorder so that we fill 2002 first before 2001

 

Impute Rolling Average.png

Raj
16 - Nebula

@ed_hayter  thanks for help

Labels
Top Solution Authors