This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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...
Here you go. I had to venture into macro land for this one.
The main WF just sets things up for the batch macro
The control parameter modifies the Filter tool with each iteration. The 1st one is [RecordID]<=1, 2nd is [RecordID]<=2, etc and the Summarize tool calculates the median for all records available in this iteration. The output of each iteration is unioned with the previous ones resulting in