| Advanced Tables - Table Plus |
|---|
| columnStyles | width:10px,width:25%,width:20%,width=20px,width:40%,width:15% |
|---|
| autoNumberSort | true |
|---|
| heading | 1 |
|---|
| width | 100% |
|---|
| enableHeadingAttributes | false |
|---|
| autoNumber | true |
|---|
| enableSorting | true |
|---|
|
| Parameter | Value | Opt. | Description | Example |
|---|
| 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 |
|---|
| columnStyles | width:10px,width:25%,width:20%,width=20px,width:40%,width:15% |
|---|
| autoNumberSort | true |
|---|
| heading | 1 |
|---|
| width | 100% |
|---|
| enableHeadingAttributes | false |
|---|
| autoNumber | true |
|---|
| enableSorting | true |
|---|
|
| Parameter | Value | Opt. | Description | Example |
|---|
| 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 |
|---|
|
| Translation | Rastern 8.0 |
|---|
| GUID | ? |
|---|
| Internal | TimeRaster8 |
|---|
| Version | 8 |
|---|
| Legacy | - |
|---|
| Assembly | xi.OpMisc |
|---|
| TotalUsage | ? |
|---|
| Status | |
|---|
| Class | |
|---|
|
|