Forum Discussion

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago
Solved

Days to Complete a process

Hello Community:

I am trying to compare the hospitals on how many days does it take on average(Hospital Average) to get thru all four treatments. 

I will insert link for file with explanation on page 3. The data is  not exact - just showing one possible result.

 

I will also paste below an an example on how I got the averages for the NC Hospital for each step.

 

Thanks for any input on getting the Hospital Average to Cover(Days) the range of Steps 1 thru 4, able to be totalled and also filterable by hosptial or patient.

 

https://drive.google.com/file/d/1snUbqhFrNDCKNyFBhJAa4Nnyg_dxabbB/view?usp=sharing

 

HosptPatientTypeStepTime InTime OutDaysForumla  
NCARadiologyStep 15/2/2022 12:05 p.m.5/2/2022 1:05 p.m.1   
NCBRadiologyStep15/2/2022 1:05 p.m.5/2/2022 3:05 p.m.1   
NCARadiologyStep 25/4/2022 12:05 p.m.5/4/2022 1:05 p.m.1.95Time out 5-04 -Time Out 5-02
NCBRadiologyStep 25/4/2022 1:05 p.m.5/4/2022 2:05 p.m.1.95Time out 5-04 -Time Out 5-02
NCARadiologyStep 35/9/2022 12:05 p.m.5/9/2022 1:05 p.m.5Time out 5-09 -Time Out 5-04
NCBRadiologyStep 35/9/2022 1:05 p.m.5/9/2022 2:05 p.m.5Time out 5-09 -Time Out 5-04
NCARadiologyStep 45/16/2022 12:05 p.m.5/16/2022 2:05 p.m.7.04Time out 5-16 -Time Out 5-09
NCBRadiologyStep 45/16/2022 1:05 p.m.5/16/2022 2:05 p.m.7Time out 5-16 -Time Out 5-09
    AVG DAYS (all patients)     
  NCStep 11     
  NCStep 21.95     
  NCStep 35     
  NCStep 47.02     
   Tot Avg14.97 

The finaloutput would directionally look like this:

Thanks!

 

 

  • vapid128's avatar
    vapid128
    4 years ago

     

     

    In Table add colnum

    days = 
if([Step_ID]=1,
    1,
    [Time Out]-LOOKUPVALUE('Table'[Time Out],'Table'[Step_ID],'Table'[Step_ID]-1,'Table'[Patient_ID],'Table'[Patient_ID])
)

     

    add measure

    aveDays = AVERAGEX(VALUES('Table'[Patient_ID]),CALCULATE(SUM('Table'[days])))

2 Replies

  • vapid128's avatar
    vapid128
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

     

     

    In Table add colnum

    days = 
if([Step_ID]=1,
    1,
    [Time Out]-LOOKUPVALUE('Table'[Time Out],'Table'[Step_ID],'Table'[Step_ID]-1,'Table'[Patient_ID],'Table'[Patient_ID])
)

     

    add measure

    aveDays = AVERAGEX(VALUES('Table'[Patient_ID]),CALCULATE(SUM('Table'[days])))