Census between different intervals using intervalmatch

kourosh_r — Tue, 22 Jul 2025 14:29:37 GMT

Hello,

I am trying to find the product census for different hours between different timestamps.

For example I want to know the number of products from

StartTimeA to TimeA

TimeA to TimeB

TimeB to EndTime

TimeA to EndTime

or ...

sample data

Input:

Load * inline [

Product , StartTime, TimeA, TimeB, EndTime

A, 09/27/17 17, 09/27/17 19, 09/27/17 20, 09/27/17 20

B, 08/21/17 13, 08/21/17 13, 08/21/17 14, 08/21/17 14

C, 08/23/17 11, 08/23/17 11, 08/23/17 16, 08/23/17 16

D, 09/11/17 15, 09/11/17 16, 09/11/17 16, 09/11/17 16

E, 10/08/17 12, 10/08/17 13, 10/09/17 01, 10/09/17 00

F, 10/08/17 19, 10/08/17 20, 10/08/17 21, 10/08/17 21

];

I also have a master calendar and [DateHour] with the same format 'MM/DD/YYYY hh'

How could I calculate all the required census for every hour utilizing intervalmatch?

Thank you in advance.

-Kourosh

topic Census between different intervals using intervalmatch in Archived Groups