Regarding Overlapping dates

Mon, 21 Sep 2015 14:56:57 GMT

Hello Friends,

Is there any way to see all the overlapping contract ids for a particular product id in the below script?

eg:

product-id, contract-id ,start-date ,end-date

p1, c1, 25/1/15, 29/1/15

p1, c2, 26/1/15, 25/2/16

p1, c3,23/2/16, 25/5/17

Here I would like to see all the contract ids c1,c2 and c3 , hence they are all overlapping in the given period.

I have attached the script for your reference.

Thanks,

Kiruthi

Re: Regarding Overlapping dates

hic — Mon, 21 Sep 2015 15:06:34 GMT

I would approach it in a different way.

First, I would create all dates possible within each interval. See Creating Reference Dates for Intervals for doing this.

Then I would use a chart with date as dimension and the following as expressions:

Count( distinct [contract-id])

Concat( distinct [contract-id], ',')

HIC