Provider Prior to Upgrade

Data_Devon

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 :)

ColemenWilson

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.

ColemenWilson

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. https://domo-support.domo.com/s/article/360042922814?language=en_US

Data_Devon

@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?

ColemenWilson

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.

Data_Devon

🐐🐐🐐🐐 Thank you!

(we need a new reaction for the GOATs)