Builds per-second histograms (within-N-seconds) by queue, media type, direction.
Anchors each record in the interval where the ACD Interact ended; wait seconds = Delay + Interact.
Uses segments.db_last_updated savepoint; recomputes only affected daily windows. Supports Postgres and SQL Server.
Parameters
| Parameter | Description | |
|---|---|---|
| savepoint | Optional | Named savepoint. Default 'queue_seconds'. |
| start_date | Optional | Optional override for savepoint start. |
| end_date | Optional | Optional end date. Default now (UTC). |
| granularity | Optional | TimeSpan for bucket size (e.g., '15 minutes' or '30 minutes'). Default is 15 minutes. |
| max_seconds_cap | Optional | Optional cap for seconds bucket (e.g., 3600). -1 disables (default). |
Tables Affected
Variables Set
No variables set.
Permissions needed
- analytics:conversationDetail:view
Examples
- queue_second_histograms(granularity='15 minutes')