1 Reply Latest reply on Oct 9, 2018 10:31 AM by Ken Flerlage

    Average Volumes Per Minute

    Anthony Simpson

      Morning,

       

      I'm trying to calculate the average datapoints for the same minute in the same day of the week. For example compare the total from 00:01:00 on Monday 17th September to 00:01:00 on Monday 24th September but exclude all other days of the week. I'm currently using an LOD below which brings me to comparing the 01 Minute across all hours of all Monday's but i cannot make it specifically look at 00:01:00

       

      {EXCLUDE

      [Datetime (Days)],[Datetime (Hours)]

      :avg([DataPoints

       

      Can anyone help?