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

  • 1 min
  • 2 min
  • 5 min
  • 10 min
  • 15 min
  • 30 min
  • 1 hrs
  • 2 hrs
  • 3 hrs
  • 4 hrs
  • 8 hrs
  • 12 hrs
  • 1 day
  • 1 week
  • 1 month
  • 1st quarter
  • 1st half-year
  • 1 year

-

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.

Related topics