Calculating Admission days using IntervalMatch

[Sharbel]

Hi,

I am trying to use IntervalMatch on source table (see Sample) in order to get the Target table as depicted below:

the purpose is to be able to calculate admission days per month/year.

Any Ideas?

Regards,

Sharbel

[tealowk · Accepted solution]

Hi Sharbel,

to achieve the intended result - calculate the admission days per Month/Year - you can create a Months table and then check every VisitID against the respective month.

This way you are able to analyse the admission days per Month and Year.

Hope this helps - even if it's not using the intervalMatch prefix.

Kind regards from Brussels,

Thilo

[Sharbel]

Thanks Thilo!