Performance Metrics - 311 Call Center
City of Chicago
@usgov.city_of_chicago_performance_metrics_311_call_center
City of Chicago
@usgov.city_of_chicago_performance_metrics_311_call_center
CREATE TABLE table_1 (
"sort" BIGINT,
"dates" VARCHAR,
"average_number_of_operators_mon_fri_7_00am_3_00pm" DOUBLE,
"average_number_of_operators_mon_fri_3_00pm_11_00pm" DOUBLE,
"average_number_of_operators_mon_fri_11_00pm_7_00am" DOUBLE,
"average_number_of_operators_sat_sun_7_00am_3_00pm" DOUBLE,
"average_number_of_operators_sat_sun_3_00pm_11_00pm" DOUBLE,
"average_number_of_operators_sat_sun_11_00pm_7_00am" DOUBLE,
"call_volume_7_00am_3_00pm" DOUBLE,
"call_volume_3_00pm_11_00pm" DOUBLE,
"call_volume_11_00pm_7_00am" DOUBLE,
"efficiency_7_00am_3_00pm" DOUBLE,
"efficiency_3_00pm_11_00pm" DOUBLE,
"efficiency_11_00pm_7_00am" DOUBLE,
"utilization_7_00am_3_00pm" DOUBLE,
"utilization_3_00pm_11_00pm" DOUBLE,
"utilization_11_00pm_7_00am" DOUBLE,
"abandoned_7_00am_3_00pm" DOUBLE,
"abandoned_3_00pm_11_00pm" DOUBLE,
"abandoned_11_00pm_7_00am" DOUBLE,
"average_wait_time_seconds_7_00am_3_00pm" DOUBLE,
"average_wait_time_seconds_3_00pm_11_00pm" DOUBLE,
"average_wait_time_seconds_11_00pm_7_00am" DOUBLE
);
Anyone who has the link will be able to view this.