I have a dataset with start and stop dates for employees. Employee id start_dt stop_dt 123 1/1/2014 4/1/2015 123 3/1/2015 12/31/2016 123 6/1/2018 12/2/2020 123 1/2/2021 222 1/1/2020 12/3/2020 222 4/2/2019 12/31/2019 333 1/1/2018 12/31/2019 333 1/2/2018 12/31/2019 333 1/3/2018 12/31/2020 I want to find out how many concurrent time periods are in above dataset for each employee. Employee id Conflicts 123 1 222 0 333 3 Thank you.
... View more