2 Replies Latest reply on May 7, 2018 6:00 AM by William Nichols

    Count how many times a max value occurs during a time interval over a month

    William Nichols

      I'm trying to get a count of how many times a daily peak occurs at different time intervals.

       

      So ,if over a month, the daily max occured at 3pm, 15 times that's what I would want to show. Something like below:

       

                 

      TotalJune (30)July (31)August (31)September (30)
      15:0033%14%00%13%13%
      15:1500%00%00%00%00%
      15:3076%27%413%00%13%
      15:4533%00%00%27%13%
      16:0065%14%27%13%27%
      16:1533%14%13%13%00%
      16:301614%27%13%517%827%
      16:452521%725%930%621%310%
      17:004236%932%1033%1034%1343%
      17:1533%00%27%13%00%
      17:3033%27%00%00%13%
      17:4543%311%00%13%00%
      18:0022%00%13%13%00%