WFMTimeseriesReport
Query the WFM Timeseries Report via the Explore API. Provides timeseries data for generating forecasts and schedules within WFM production. Up to a month of data per request.
Select
The WFMTimeseriesReport is a report view. The connector processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the connector defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM WFMTimeseriesReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| IntervalStart | Datetime | The start time of the interval. | |
| QueueName | String | The name of the queue. | |
| ForecastedAvgHandleTime | Double | The forecasted average handle time. | |
| ForecastedInteractiveVolumeOffered | Double | The forecasted interactive volume offered. | |
| HistoryAbandonedVolume | Double | The historical abandoned volume. | |
| HistoryAvgHandleTime | Double | The historical average handle time. | |
| HistoryAvgTimeToAbandon | Double | The historical average time to abandon. | |
| HistoryAvgWaitTime | Double | The historical average wait time. | |
| HistoryBacklog | Double | The historical backlog. | |
| HistoryInteractionVolumeOffered | Double | The historical interaction volume offered. | |
| HistoryOccupancy | Double | The historical occupancy rate. | |
| HistoryServiceLevelPercentage | Double | The historical service level percentage. | |
| HistoryStaffing | Double | The historical staffing level. | |
| PredictedAbandonedVolume | Double | The predicted abandoned volume. | |
| PredictedAvgHandleTime | Double | The predicted average handle time. | |
| PredictedAvgTimeToAbandon | Double | The predicted average time to abandon. | |
| PredictedAvgWaitTime | Double | The predicted average wait time. | |
| PredictedBacklog | Double | The predicted backlog. | |
| PredictedInteractionVolumeOffered | Double | The predicted interaction volume offered. | |
| PredictedOccupancy | Double | The predicted occupancy rate. | |
| PredictedRequiredStaffing | Double | The predicted required staffing level. | |
| PredictedServiceLevelPercentage | Double | The predicted service level percentage. | |
| PredictedStaffing | Double | The predicted staffing level. | |
| RequiredServiceLevelPercentage | Double | The required service level percentage. | |
| RequiredStaffing | Double | The required staffing level. | |
| Shrinkage | Double | The shrinkage percentage. | |
| HandleTime | Double | The handle time. | |
| VolumeHandled | Double | The volume of interactions handled. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |