Find overlapping date ranges and add corresponding performance metrics to measure efficiency

Hi Anonymous ， 

I am not clear about your requirement, could you please explain the logic of "loading status" and if possible, could you please inform me your current design in gantt chart and your expected output? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.