Microsoft Teams widgets – Call Queue Summary

Definition

Summary of Microsoft call queues and the Final Call Result, including total Talk Time, Average Connection Time, and the Longest Connection Time for each of the call outcomes.

Sample output

Prism analytics widget screenshot

Widget definition

{"ViewGuid":"60fc411c-f55b-4a25-b9a9-9ff26bfa0c03","Definition":{"ColumnAggregates":[{"Alias":"callQueue_CallQueueName_df1d5bc8f465b628","Label":"Call Queue Name","ColumnId":"callQueue_CallQueueName","AggregateType":"Value","IsAggregate":false,"Type":-2},{"Alias":"callQueue_FinalCallResult_d0cd8e51fa4dc494","Label":"Final Call Result","ColumnId":"callQueue_FinalCallResult","AggregateType":"Value","IsAggregate":false,"Type":-2},{"Alias":"callQueue_CallTalkMeasure_b4230cac7e44ea49","Label":"Sum(Call Talk Time)","ColumnId":"callQueue_CallTalkMeasure","AggregateType":"Sum","IsAggregate":false,"Type":-1},{"Alias":"factCall_DurationMilliseconds_7c6ed6ad608e75a1","Label":"Sum(Call Duration)","ColumnId":"factCall_DurationMilliseconds","AggregateType":"Sum","IsAggregate":false,"Type":-1},{"Alias":"callQueue_CallConnectionMeasure_ebc11dba2887f115","Label":"Average(Call Connection Time)","ColumnId":"callQueue_CallConnectionMeasure","AggregateType":"Average","IsAggregate":false,"Type":-1},{"ColumnId":"callQueue_CallConnectionMeasure","IsNew":true,"Type":-1,"AggregateType":"Maximum","Alias":"callQueue_CallConnectionMeasure_b2e93cb4fd8aa25b","Label":"Maximum(Call Connection Time)"},{"ColumnId":"callQueue_CallCountMeasure","IsNew":true,"Type":-1,"AggregateType":"Count","Alias":"callQueue_CallCountMeasure_1c5de2aedba44a87","Label":"Count(Call Count)"}],"PreFilters":[],"PreGroupFilters":[],"Parameters":{"SelectedTreeId":"1","DateSelectionMethod":"UseQuickDates","QuickDate":{"Type":"6","FromLocal":"01/01/2024 00:00:00","ToLocal":"31/12/2024 23:59:59"}},"GridSettings":"{\"columns\":[{\"index\":0,\"field\":\"callQueue_CallQueueName_df1d5bc8f465b628\",\"width\":154.295,\"hidden\":false},{\"index\":1,\"field\":\"callQueue_FinalCallResult_d0cd8e51fa4dc494\",\"width\":167.52411,\"hidden\":false},{\"index\":2,\"field\":\"callQueue_CallTalkMeasure_b4230cac7e44ea49\",\"width\":147.68011,\"hidden\":false},{\"index\":3,\"field\":\"factCall_DurationMilliseconds_7c6ed6ad608e75a1\",\"width\":441.88211,\"hidden\":false},{\"index\":4,\"field\":\"callQueue_CallConnectionMeasure_ebc11dba2887f115\",\"width\":187.36811,\"hidden\":false},{\"index\":5,\"field\":\"callQueue_CallConnectionMeasure_b2e93cb4fd8aa25b\",\"width\":246.88210999999998,\"hidden\":false},{\"index\":6,\"field\":\"callQueue_CallCountMeasure_1c5de2aedba44a87\",\"width\":293.65310999999997,\"hidden\":false}],\"sortDir\":\"Asc\",\"sortField\":null,\"pageSize\":50}"},"DefinitionVersion":1}

You might also like…