Advanced conditional columns

The nurse manager of your department has requested an analysis of visits during their after-hours periods to determine if staffing is well aligned with demand. They also want to assess a breakdown of severity scores (ESI) during this after-hours period.

You must create a grouping to isolate visits during the specified range.

Note the following time range bins define the hour range for patient arrivals within the arrivalhour_bin column:

• 07-10: (07:00 am - 10:59 am)
• 11-14: (11:00 am - 2:59 pm)
• 15-18: (3:00 pm - 6:59 pm)
• 19-22: (7:00 pm - 10:59 pm)
• 23-02: (11:00 pm - 2:59 am)
• 03-06: (3:00 am - 6:59 am)

If you lost progress, load the workbook 2_2_advanced_conditional_columns.xlsx from the Workbooks folder and launch the Power Query editor.