I'm not sure if you have understood the question, I'm sorry for not being so clear. In how many hours (in past 3 hours, 180min/3) that combination has the record. Not how many matches(record) has in each hour. Maybe someone has just the record in 14:03, 14:05, 14:19, 14:55, 15:02, and that need to be count=1. Because the range is <60min and it does not matter how many records have in that range. If the range is between 0min-60min and 60min-120min it is 2 (example 14:01, 14:03, 14:05, 14:19, 14:55, 15:02) , if it's between 0min-60min, 60min-120min and 120min-180min, that's count=3 (example 14:01, 14:03, 14:05, 14:19, 14:55, 15:02, 16:04), because have records in all the 3 past hours. Range >180min I don't look at all, need to take observation for each record just the past 3 hours.
... View more