Conversion of time pattern
Summary
Converts the time pattern between intervals of 15, 30 or 60 minutes, 1 day, 1 week, 1 month or 1 year.
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
From | System.DateTime | - | This is the From column of the data table. | - |
To | System.DateTime | - | This is the To column of the data table. | - |
Queues | System.String | opt. | This is the queue column of the data table. If this column is specified, the others are considered separately on the basis of queues. | - |
Day type | System.String | opt. | This is the day type column of the data table. If this column is specified, the others are considered separately on the basis of day types. | - |
Data columns | System.Object | - | The data columns of the input table, e.g. number of calls, AHT, ... | - |
Settings
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Total | System.String | - | Values are added up while being merged, and evenly distributed in distribution mode. | - |
Weighted | System.String | - | During summarizing, values are averaged by weighting them on the basis of calls and they are copied into all target rows during distributing. Use "Average" for an average value which does not have to be weighted. | - |
Average | System.String | - | While being merged, the values are averaged. When distributed, values are copied into all the target rows. Averaging is not weighted. Use the columns "Weighted" for a weighted calculation. | - |
Length of time interval | System.Integer
| - | Length of time intervals in target time pattern. | - |
Fill up period | System.Boolean | - | If rows are missing in the specified period, the missing rows are added. While doing so, the values are set to 0. | - |
Start | System.String | opt. | Beginning of the period to be filled in. | - |
End | System.String | opt. | End of period to be filled in. | - |
Fill up missing days | System.Boolean | - | If days are missing, the missing rows are added. While doing so, the values are set to 0. | - |
Remarks
Possible alternativ: Scaling 8.2
Want to learn more?
Screenshot
Troubleshooting
Nothing known up to now.