Moving Median

[JamesBills]

Hello Community,

I want to calculate how the Median has progressed over time. Other than splitting the data up by the date, then calculating median for each group of data, is there another way to do this? 

I have 50+ dates and values, so will to time consuming to split up data manually then do the calculation with a summarise tool. Ideally I want to calculate the median, then add in next value, recalculate median...

ie. A median for every line. 

Thanks for your help in advance, 

James

[danilang]

Hi @JamesBills 

Alteryx workflows and macros are just xml files.  Open the .yxmd and .yxmc in notepad and change the second line in each to

<?xml version="1.0"?>
<AlteryxDocument yxmdVer="2019.1">
<Nodes>

Neither of them use 2019.2 specific features so you should be able to open them after this change.

Note.  don't try this with the .yxzp file.  It's actually a renamed zip file and not comprehensible to mere mortals.

Dan