Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSettings

Columns of input table


Advanced Tables - Table Plus
columnStyleswidth:10px,width:25%,width:20%,width=20px,width:40%,width:15%
autoNumberSorttrue
heading1
width100%
enableHeadingAttributesfalse
autoNumbertrue
enableSortingtrue


ParameterValueOpt.DescriptionExample
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".-



Parameters


Advanced Tables - Table Plus
columnStyleswidth:10px,width:25%,width:20%,width=20px,width:40%,width:15%
autoNumberSorttrue
heading1
width100%
enableHeadingAttributesfalse
autoNumbertrue
enableSortingtrue


ParameterValueOpt.DescriptionExample
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
-

This parameter sets the calculation method, see Calculation methods for details.

-
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.-



Page properties
hiddentrue


TranslationRastern 8.0
GUID?
InternalTimeRaster8
Version8
Legacy-
Assemblyxi.OpMisc
TotalUsage?
Status

Status
colourYellow
titleEDITING

Class
Status
titleData



...