Re: Rolling Averages

mahouser · ‎03-15-2019

I'm trying to calculate a rolling 8 hour average of a dataset that is based on a certain ranges of hours during the day. The rolling average is based on the next 7 hours versus the last 7 hours of the data set.

Stachu · ‎03-18-2019

can you share the sample from your data table?

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

mahouser · ‎04-10-2019

Here is a 24 hour reading of Ozone Detectors at 2 different locations:

SiteName	Date	TimeOnly	RawValue	ParameterName
ALLENTOWN	4/9/2019 0:00	1/1/1900 0:00	37.6604238	OZONE
ALLENTOWN	4/9/2019 1:00	1/1/1900 1:00	51.8286431	OZONE
ALLENTOWN	4/9/2019 2:00	1/1/1900 2:00	33.3010703	OZONE
ALLENTOWN	4/9/2019 3:00	1/1/1900 3:00	25.1576716	OZONE
ALLENTOWN	4/9/2019 4:00	1/1/1900 4:00	14.1241395	OZONE
ALLENTOWN	4/9/2019 5:00	1/1/1900 5:00	6.816389	OZONE
ALLENTOWN	4/9/2019 6:00	1/1/1900 6:00	2.9791184	OZONE
ALLENTOWN	4/9/2019 7:00	1/1/1900 7:00	8.0167436	OZONE
ALLENTOWN	4/9/2019 8:00	1/1/1900 8:00	22.1414316	OZONE
ALLENTOWN	4/9/2019 9:00	1/1/1900 9:00	31.8019635	OZONE
ALLENTOWN	4/9/2019 10:00	1/1/1900 10:00	34.8055257	OZONE
ALLENTOWN	4/9/2019 11:00	1/1/1900 11:00	37.7383288	OZONE
ALLENTOWN	4/9/2019 12:00	1/1/1900 12:00	40.7607785	OZONE
ALLENTOWN	4/9/2019 13:00	1/1/1900 13:00	46.4895289	OZONE
ALLENTOWN	4/9/2019 14:00	1/1/1900 14:00	50.0073843	OZONE
ALLENTOWN	4/9/2019 15:00	1/1/1900 15:00	51.3552042	OZONE
ALLENTOWN	4/9/2019 16:00	1/1/1900 16:00	49.1176533	OZONE
ALLENTOWN	4/9/2019 17:00	1/1/1900 17:00	55.3614572	OZONE
ALLENTOWN	4/9/2019 18:00	1/1/1900 18:00	54.7438224	OZONE
ALLENTOWN	4/9/2019 19:00	1/1/1900 19:00	50.4877652	OZONE
ALLENTOWN	4/9/2019 20:00	1/1/1900 20:00	47.0916684	OZONE
ALLENTOWN	4/9/2019 21:00	1/1/1900 21:00	44.0666383	OZONE
ALLENTOWN	4/9/2019 22:00	1/1/1900 22:00	43.8841775	OZONE
ALLENTOWN	4/9/2019 23:00	1/1/1900 23:00	42.9678238	OZONE
ALTOONA	4/9/2019 0:00	1/1/1900 0:00	12.2370668	OZONE
ALTOONA	4/9/2019 1:00	1/1/1900 1:00	36.7026419	OZONE
ALTOONA	4/9/2019 2:00	1/1/1900 2:00	5.3685712	OZONE
ALTOONA	4/9/2019 3:00	1/1/1900 3:00	4.834824	OZONE
ALTOONA	4/9/2019 4:00	1/1/1900 4:00	7.3706357	OZONE
ALTOONA	4/9/2019 5:00	1/1/1900 5:00	9.1384022	OZONE
ALTOONA	4/9/2019 6:00	1/1/1900 6:00	13.8618639	OZONE
ALTOONA	4/9/2019 7:00	1/1/1900 7:00	30.866188	OZONE
ALTOONA	4/9/2019 8:00	1/1/1900 8:00	42.7330005	OZONE
ALTOONA	4/9/2019 9:00	1/1/1900 9:00	47.8913017	OZONE
ALTOONA	4/9/2019 10:00	1/1/1900 10:00	48.5476867	OZONE
ALTOONA	4/9/2019 11:00	1/1/1900 11:00	48.9249702	OZONE
ALTOONA	4/9/2019 12:00	1/1/1900 12:00	47.0881995	OZONE
ALTOONA	4/9/2019 13:00	1/1/1900 13:00	55.398166	OZONE
ALTOONA	4/9/2019 14:00	1/1/1900 14:00	58.7230554	OZONE
ALTOONA	4/9/2019 15:00	1/1/1900 15:00	57.4781236	OZONE
ALTOONA	4/9/2019 16:00	1/1/1900 16:00	54.7125648	OZONE
ALTOONA	4/9/2019 17:00	1/1/1900 17:00	54.3139076	OZONE
ALTOONA	4/9/2019 18:00	1/1/1900 18:00	52.5315857	OZONE
ALTOONA	4/9/2019 19:00	1/1/1900 19:00	51.6327021	OZONE
ALTOONA	4/9/2019 20:00	1/1/1900 20:00	50.2883429	OZONE
ALTOONA	4/9/2019 21:00	1/1/1900 21:00	47.9600911	OZONE
ALTOONA	4/9/2019 22:00	1/1/1900 22:00	42.757117	OZONE
ALTOONA	4/9/2019 23:00	1/1/1900 23:00	37.6118286	OZONE

I need to calculate an hourly rolling average for Ozone over an 8 hour period (Time + 7 Hours Forward) per Site. I'm hoping to do this in DirectQuery Mode.