ESdat Forums
»
Forums
»
ESdat
»
Calculating Rolling Median
Rank: Newbie
Groups: Registered
Posts: 4 Location: Sydney, NSW, Aus
|
Hi guys, I need to calculate a rolling median for water results across a period starting on the 25th of the current month and ending on the 24th of the next month. We'll have approx. 5-10 samples per month and I'm producing a chem output table following the completion of a reporting period (i.e. after the 24th of the month). To demonstrate changes in the median over that reporting period, I'd like to have the median recalculated after each sample. Is there a way to set up my output tables to do this so I don't have to edit after table creation?
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hi Joe, So every second line in the table would be a result and every other line an updated median? That would need a custom report to do that, it's not something that can be produced with the standard reprots. Contact me directly if you'd like more details. Warwick
|
|
|
|
Rank: Newbie
Groups: Registered
Posts: 4 Location: Sydney, NSW, Aus
|
Thanks Warwick - yes, that's right (unless we can come up with a better layout). A custom report would be worth looking into for this. I'll get in touch with you in the next 1-2 days after I get some ducks in a row.
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Calculating Rolling Median
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.