Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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