Summary

Calculates the minimum and maximum of a set

  • for nodes with 0-2 identifiers
  • writes the result in a new column

Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

From

System.DateTime

-

This is the From column of the data table.

"col1"

To

System.DateTime

-

This is the To column of the data table.

"col2"

Data column

System.Double

-

This column contains the data to be searched through.

"col3"

Day type

System.String

opt.

Day type for a day-type based search.

"col4"

Queue

System.String

opt.

Queue for a queue-by-queue search.

"col5"

Remarks

  • Day type can be used as an identifier 
  • Queue can be used as an identifier
  • You can not use more than 2 identifier, if necessary you can summarize columns beforehand.

Want to learn more?

Screenshots


Examples

Example: Calculate Min/Max

Situation

This example shows you how to use the operator "Calculate Min/Max"

Settings

Note:

  • Day type can be used as an identifier 
  • Queue can be used as an identifier
  • You can not use more than 2 identifier, if necessary you can summarize columns beforehand.

Result

Project File

-


Troubleshooting

Problem

Frequent Cause

Solutions

Amount identifier

You can not use more than 2 identifier.

If necessary you can summarize columns beforehand.

Related topics