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 t...
Need Help
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.