Datasets

Datasets

Provider Prior to Upgrade

Contributor

I am trying to determine who provided the evaluation prior to an upgraded premium procedure.

I have all the data I could ever need, but I'm not sure of the logic to make it happen. The task is made more difficult because there could be multiple evaluations prior to a procedure, and evaluations on different dates than the procedure.

Here's a simple example of the ingredients I have to work with:

The goal is ultimately this: Nurse A has patients that do upgraded procedures 50% of the time, and Nurse B has patients that do upgraded procedures 5% of the time. Why does Nurse B have less upgraded patients? What is Nurse A doing differently?

This is a big initiative so would be a huge win :)

✅Did this solve your problem? Accept it as a solution!

❤️Did you love this answer? Mark it as "Awesome"!

👍Do you agree with this process? Click "Agree"!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In

Best Answer

  • Answer ✓

    In your table it shows "Evaluation". Aren't you looking to see who did the evaluation prior to the upgraded procedure? If so just filter out anything that isn't "Evaluation" or "Upgraded Procedure" then do the lag function and you'll get who did the evaluation prior to each upgraded procedure. Be sure to partition on patient.

    If I solved your problem, please select "yes" above

Answers

  • I am assuming you also have dates? Do you have a date time? Some way to order the events taking place? If so you could use a lag function and look for the procedure that occurred prior to the Upgraded Procedure. Site faviconCustomer Support Community

    If I solved your problem, please select "yes" above

  • Contributor

    @ColemenWilson - yes, I've got dates and times. That should do the trick - but there won't be a set rule for the pre-procedure events. I.e. It could be any number of things that happen before an upgraded procedure, so there won't be a rule that standardizes it.

    Do you think this will be an issue?

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

  • Answer ✓

    In your table it shows "Evaluation". Aren't you looking to see who did the evaluation prior to the upgraded procedure? If so just filter out anything that isn't "Evaluation" or "Upgraded Procedure" then do the lag function and you'll get who did the evaluation prior to each upgraded procedure. Be sure to partition on patient.

    If I solved your problem, please select "yes" above

  • Contributor

    🐐🐐🐐🐐 Thank you!

    (we need a new reaction for the GOATs)

    ✅Did this solve your problem? Accept it as a solution!

    ❤️Did you love this answer? Mark it as "Awesome"!

    👍Do you agree with this process? Click "Agree"!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In