Background
CompressedA contains statistics regarding:
- Calls to Service Numbers
- Calls made to ACD groups
- Calls made to agents (summary for the ACD group)
Information such as:
- The number of calls
- Answered
- Busy
- Rejected
- Abandoned
- Service indicators for calls
- Calls received in standard service times
- Calls in service level according to 4 different criteria
- Call transfers
- Agent to agent
- Agent to group
- Agent to external destination
- Times for calls
- From call start to end
- From offhook to end
- From call start to connection to agent
- ...
is provided.
Note: because these statistics are aggragated, not quite as much information is available as from the call detail records. However, this aggregated data can be retained for a much longer time.
Parameters
Data is aggregated according to the settings of the parameters:
Parameter | Default Value | Purpose |
Portal.ACD.Statistics.JTELStats2.Compress.StatisticsServiceNumbers.SecondsToWait | 7200 | The minimum time after the end of a time interval before statistics are aggregated. |
Portal.ACD.Statistics.JTELStats2.Compress.StatisticsServiceNumbers.NextTimeSlice | - | The date / time of the next time slice to be calculated. This parameter can be reset to an earlier date / time in which case the system will recalculate all intervals from the given date and time again. |
| Portal.ACD.Statistics.JTELStats2.Compress.StatisticsServiceNumbers.CustomCompress | The name of a stored procedure, in JTELStats2, which is called after the system statistics discussed below have been aggregated. This can be used to provide additional values in additional tables as required by a custom installation. NOTE: changing the CompressedA tables themselves is NOT supported. | |
| Portal.ACD.Statistics.JTELStats2.Compress.StatisticsServiceNumbers.CustomCompress.SuppressErrors | 0 | Set to 1, to suppress errors in the CustomCompress routine. If this flag is set, the system will continue with calculations for the CompressedA data, even if the custom routine throws errors. |
Query
Two tables are provided, compressed CompressedA15 (15 minute time slices) and CompressedADay (day compression), aggregated according to the following query:
...