>In which realistic scenario would you ever need to ask such questions in the first place? Not related to payment processing but I do this kind of sliding time

>In which realistic scenario would you ever need to ask such questions in the first place? Not related to payment processing but I do this kind of sliding time aggregation a lot at my work we have two 12 hour shifts. Often you need to be able to compute data across shift boundaries and batch things to gether at set intervals. I.E 'How many alarms events occurred this shift?' 'What about the previous shift?' 'How many four nightshift's previously?'