How to calculate overlapping dates

 Hi all,

I have a dataset in which I have different maintenance categories. I'd like to calculate overlapping maintance categories. In the example provided, I want to know if (and how many times) maintenance categery A is overlapping with other maintenance categories. The thing is, I can calculate this for a previous or next row of data, but I actually want to measure and end date for one row against the whole range of start dates. In the dataset provided, for maintenance category A, there are 2 overlapping maintenance categories, ID C (Category A) has ID B and D overlapping and ID F has ID D, G and H overlapping.

Any ideas on how to calculate this in Spotfire?

kind regards,
David Boot-Olazabal


Binary Data overlap_onderhoudsinterval.dxp191.39 KB

(1) Answer