Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Joe Ferring  
#1 Posted : Friday, October 20, 2017 9:05:18 AM(UTC)
Joe Ferring
Rank: Newbie

Reputation:

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? 

Warwick Wood  
#2 Posted : Friday, October 20, 2017 5:49:05 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
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

Joe Ferring  
#3 Posted : Monday, October 23, 2017 6:49:39 AM(UTC)
Joe Ferring
Rank: Newbie

Reputation:

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.

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.