Forum Discussion
Overlapping client sessions
Super Usersince i am not familiar to your business, could you pls provide the output with data based on the sample data you provide, not only the layout.
what's more, for the 97155, i only see one provide id 1431089 and do not have any overlap with other records.
Here is a link to the full dataset, I apologize that the sample did not have an overlap, which negates the whole question, I was trying to keep it simple and just made things harder. different providers provider service to clients but only our supervisors provide the oversight or the 97155 codes. I am only concerned with the cross over of 97153 & 97155 codes for this specific review. The ID column is a unique code to each service line, client and provider ID unique identifer to each person. I am trying to find the percent of time an employee is supervised versus their total time worked with clients.
Again any help is appreciated as I am completely stumped right now.
https://1drv.ms/u/s!Aj9-fJ8Jdp0o0xyzsDnb4FONpJmH?e=tLMf65