Census between different intervals using intervalmatch

[kourosh_r]

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

or

                TimeA to TimeB

or

                 TimeB to EndTime

or

                 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