Forum Discussion

mahouser's avatar
mahouser
Frequent Visitor
7 years ago

Rolling Averages

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. 

Need Help

2 Replies

  • Stachu's avatar
    Stachu
    Community Champion
    7 years ago

    can you share the sample from your data table?

    • mahouser's avatar
      mahouser
      Frequent Visitor
      7 years ago

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

       

      SiteNameDateTimeOnlyRawValueParameterName
      ALLENTOWN4/9/2019 0:001/1/1900 0:0037.6604238OZONE
      ALLENTOWN4/9/2019 1:001/1/1900 1:0051.8286431OZONE
      ALLENTOWN4/9/2019 2:001/1/1900 2:0033.3010703OZONE
      ALLENTOWN4/9/2019 3:001/1/1900 3:0025.1576716OZONE
      ALLENTOWN4/9/2019 4:001/1/1900 4:0014.1241395OZONE
      ALLENTOWN4/9/2019 5:001/1/1900 5:006.816389OZONE
      ALLENTOWN4/9/2019 6:001/1/1900 6:002.9791184OZONE
      ALLENTOWN4/9/2019 7:001/1/1900 7:008.0167436OZONE
      ALLENTOWN4/9/2019 8:001/1/1900 8:0022.1414316OZONE
      ALLENTOWN4/9/2019 9:001/1/1900 9:0031.8019635OZONE
      ALLENTOWN4/9/2019 10:001/1/1900 10:0034.8055257OZONE
      ALLENTOWN4/9/2019 11:001/1/1900 11:0037.7383288OZONE
      ALLENTOWN4/9/2019 12:001/1/1900 12:0040.7607785OZONE
      ALLENTOWN4/9/2019 13:001/1/1900 13:0046.4895289OZONE
      ALLENTOWN4/9/2019 14:001/1/1900 14:0050.0073843OZONE
      ALLENTOWN4/9/2019 15:001/1/1900 15:0051.3552042OZONE
      ALLENTOWN4/9/2019 16:001/1/1900 16:0049.1176533OZONE
      ALLENTOWN4/9/2019 17:001/1/1900 17:0055.3614572OZONE
      ALLENTOWN4/9/2019 18:001/1/1900 18:0054.7438224OZONE
      ALLENTOWN4/9/2019 19:001/1/1900 19:0050.4877652OZONE
      ALLENTOWN4/9/2019 20:001/1/1900 20:0047.0916684OZONE
      ALLENTOWN4/9/2019 21:001/1/1900 21:0044.0666383OZONE
      ALLENTOWN4/9/2019 22:001/1/1900 22:0043.8841775OZONE
      ALLENTOWN4/9/2019 23:001/1/1900 23:0042.9678238OZONE
      ALTOONA4/9/2019 0:001/1/1900 0:0012.2370668OZONE
      ALTOONA4/9/2019 1:001/1/1900 1:0036.7026419OZONE
      ALTOONA4/9/2019 2:001/1/1900 2:005.3685712OZONE
      ALTOONA4/9/2019 3:001/1/1900 3:004.834824OZONE
      ALTOONA4/9/2019 4:001/1/1900 4:007.3706357OZONE
      ALTOONA4/9/2019 5:001/1/1900 5:009.1384022OZONE
      ALTOONA4/9/2019 6:001/1/1900 6:0013.8618639OZONE
      ALTOONA4/9/2019 7:001/1/1900 7:0030.866188OZONE
      ALTOONA4/9/2019 8:001/1/1900 8:0042.7330005OZONE
      ALTOONA4/9/2019 9:001/1/1900 9:0047.8913017OZONE
      ALTOONA4/9/2019 10:001/1/1900 10:0048.5476867OZONE
      ALTOONA4/9/2019 11:001/1/1900 11:0048.9249702OZONE
      ALTOONA4/9/2019 12:001/1/1900 12:0047.0881995OZONE
      ALTOONA4/9/2019 13:001/1/1900 13:0055.398166OZONE
      ALTOONA4/9/2019 14:001/1/1900 14:0058.7230554OZONE
      ALTOONA4/9/2019 15:001/1/1900 15:0057.4781236OZONE
      ALTOONA4/9/2019 16:001/1/1900 16:0054.7125648OZONE
      ALTOONA4/9/2019 17:001/1/1900 17:0054.3139076OZONE
      ALTOONA4/9/2019 18:001/1/1900 18:0052.5315857OZONE
      ALTOONA4/9/2019 19:001/1/1900 19:0051.6327021OZONE
      ALTOONA4/9/2019 20:001/1/1900 20:0050.2883429OZONE
      ALTOONA4/9/2019 21:001/1/1900 21:0047.9600911OZONE
      ALTOONA4/9/2019 22:001/1/1900 22:0042.757117OZONE
      ALTOONA4/9/2019 23:001/1/1900 23:0037.6118286OZONE

       

      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.