Identifier

System.Object

opt.

Columns containing identifiers.

If set, then the rows of the result table will be grouped according to the values in these columns. Therefore, if a scale interval is allocated more than one data interval and the data intervals have different identifiers, then the result table will contain more than one row for this scale interval: it will contain one row for each different identifier and build the sums in the "Result" (or "CNT_") and "Value" columns accordingly.

-

Date + Time (from)

System.DateTime

-

Column containing the start (date+time) of the data intervals.

-

Date + Time (to)

System.DateTime

-

Column containing the end (date+time) of the data intervals.

-

Count

System.Object

opt.

Columns containing input values to calculate the value columns of the result table. This setting is required by some calculation methods, e.g., "Proportional time*value", "Proportional value".

-

Scaling

System.Int32

• 30 seconds
• 1 minute
• 1.5 minutes
• 2 minutes
• 5 minutes
• 10 minutes
• 15 minutes
• 20 minutes
• 30 minutes
• 45 minutes
• 1 hour
• 1.5 hours (90 minutes)
• 2 hours
• 3 hours
• 4 hours
• 6 hours
• 8 hours
• 12 hours
• 24 hours
• Week
• Month
• Quarter
• Year
• Total period

-

This parameter sets the scale of the result table. It defines the length of the scale intervals and the start of the scale (see Scales).

-

Calculation method

System.String

• 100% in scale
• 50% in scale
• Start time in scale
• End time in scale
• Count start time only
• Count final time only
• Proportional time*value
• Proportional value
• Distribute value in pattern
• Smallest value in the pattern
• Largest value in pattern
• Convert hours to staffing
• Convert staffing to hours
• Maximum duration of the data row

-

-

Missing intervals

System.String

• Do not insert
• Insert all
• Insert if data exists for current week and month
• Insert if data exists for current week
• Insert if data exists for current month

-

This parameter allows to include scale intervals to which no data interval has been allocated to the result table.

• Do not insert: No scale intervals to with no allocations.
• Insert all: Insert all scale intervals between the earliest scale interval with allocation and the latest scale interval with allocation.
• Insert if data exists for current week and month: Like "insert all", but only insert scale intervals that are inside a week and month that also contains at least one scale interval with allocation.
• Insert if data exists for current week: Like "insert all", but only insert scale intervals that are inside a week that also contains at least one scale interval with allocation.
• Insert if data exists for current month: Like "insert all", but only insert scale intervals that are inside a month that also contains at least one scale interval with allocation.
  
  

-

Cancel if more than 500,000 rows?

System.Boolean

-

If this option is set, then an empty table is returned if the result table would contain more than 500,000 rows. Be careful when deselecting this because you may accidentally generate a immensely large amount of rows. 

-

Insert "Number of values" column

System.Boolean

-

Inserts an additional result column with the number of values in this interval.

Name for "Numbers of value" column

System.String

-

The name of the result column that will be added if Insert "Number of values" column is ticked

Result column layout

System.String

• From/To/Values/Key

• From/To/Key/Values

• Key/From/To/Values

-

Definition of column layout in result column.