Queries for the ACSCallSummaryUpdates table

  • Article

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Call duration percentiles

Calculates the average call duration in seconds, as well as the 50%, 90%, and 99% call duration percentiles.

ACSCallSummaryUpdates
// Get the distinct combinations of CorrelationId, CallDuration
| distinct CorrelationId, CallDuration
// Calculate average and percentiles (50%, 90%, and 99%) of call durations (in seconds)
| summarize avg(CallDuration), percentiles(CallDuration, 50, 90, 99)