Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could someone kindly tell me why I am getting an invalid expression by adding in the MonthYear into a resident table?
I get this error every time I add in a date field into my resident table
Invalid expression
ED_Patients1:
LOAD
Median([Total Wait])/1440 as Total_Wait_Median,
Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,
Median([Triage])/1440 as Triaged,
MonthYear
RESIDENT ED_Patients
Does anyone have any ideas?
Thanks
Helen
Hi,
You can try adding a Group by Function after your Resident load
ED_Patients1:
LOAD
Median([Total Wait])/1440 as Total_Wait_Median,
Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,
Median([Triage])/1440 as Triaged,
MonthYear
RESIDENT ED_Patients
group by MonthYear;
Regards,
Alex
Hi,
You can try adding a Group by Function after your Resident load
ED_Patients1:
LOAD
Median([Total Wait])/1440 as Total_Wait_Median,
Fractile([Total Wait],0.95)/1440 as Total_Wait_Fractile,
Median([Triage])/1440 as Triaged,
MonthYear
RESIDENT ED_Patients
group by MonthYear;
Regards,
Alex
Thank you! Works a treat