Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Overlapping client sessions

I am working with a overlapping report where one "provider ID" overlaps with another "provider id". Not every appointment overlaps.   Background reference is this is one provider overseeing another...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ryan_mayu,
the expected output would be a percentage of the overlap so a return similar to below. I hope this makes sense. 

I can split and total each code by provider and create certain percentages, I am struggling with defining the ovelap in the BI. Any help here would be appreciated.
Providerid (with the 97153 codes)                             supervising providerID (97155 codes)               % of overlap
     clientID                                                                                                                                             %
     ClientID                                                                                                                                             %

Providerid (with the 97153 codes)                             supervising providerID (97155 codes)               % of overlap
     clientID                                                                                                                                             %
     ClientID                                                                                                                                             %

ryan_mayu's avatar
ryan_mayu
Super User
3 years ago

since 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    ryan_mayu 

    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