Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am not sure where to start with this. I need to calculate the time between stages for each unique accession number for Mohs Surgery. From there I need to calculate the average wait time between stages for all Accession numbers with multiple stages . To be brief and not give a long explanation of Mohs surgery when a patient has Mohs surgery it may take multiple stages to remove all the tumor for a given proceedure or it may be removed in the first stage. The table looks like the following
Table: Stages
Accession Number | Stage # | Time In | Time Out |
SMM-001 | stage 1 | 8:00 | 8:15 |
SMM-001 | stage 2 | 8:36 | 8:50 |
SMM-001 | stage 3 | 9:45 | 10:00 |
SMM-002 | stage 1 | 8:30 | 9:00 |
SMM-003 | stage 1 | 10:00 | 10:20 |
SMM-003 | stage 2 | 10:30 | 10:40 |
"time in" represents the start of surgery and "time out: represents the end of surgery for that stage. Accesion SMM-001 would have two wait times of 21 and 55 min between stages, SMM-002 would have no wait time and could be ignored, and SMM-003 would have 10 min returning and average wait time of 28.7 min between stages. Any help would be greatly appreciated.
Solved! Go to Solution.
Hello @ploweyj2
download my sample file here: https://1drv.ms/u/s!AiiWkkwHZChHj1L7XRocERSQVMrN
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Hello @ploweyj2
download my sample file here: https://1drv.ms/u/s!AiiWkkwHZChHj1L7XRocERSQVMrN
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
User | Count |
---|---|
98 | |
91 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |