...
Parameter | Default Value | Purpose |
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait | 7200 | The minimum time after the end of a time interval before statistics are aggregated. |
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.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.CompressedUA.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 CompressedUA tables themselves is NOT supported. | |
| Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.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 data, even if the custom routine throws errors. |
| Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime | 02:50 | The end time beyond which the process will not run, and waits for the StartTime to pass before continuing. If empty, the process runs all the time. |
| Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime | 22:00 | The start time after which the process will start to run until the specified end time. If empty, the process runs all the time. |
Query
Two tables are provided, CompressedUA15 (15 minute time slices) and CompressedUADay (day compression), aggregated according to the following queries.
...