Reducer Processor - EcoSys - 2.0 - Help - Hexagon PPM

EcoSys Connect Help

Language
English (United States)
Product
EcoSys
Search by Category
Help
EcoSys Version
2.0

Reducer processor supports:

  • Aggregation functions such as Count, Avg, Sum, Min, and Max.

  • Grouping of columns

  1. Enter the values for the following parameters in the Basic section.

    1. Name – Specify the name

    2. Aggregate Expressions – Aggregation functions such as Count, Avg, Sum, Min, and Max.

      For example, Reducer process configured to produce the Min and Max Start Date.

Previous Step Entity Set

Project ID

Period

1

1/2018

2

1/2019

3

1/2020

Result Entity Set

Min_Period

Max_Period

2018

2020

2. In the Advanced section, click Grouping Attributes.

The Group Attributes window appears.

For example: Reducer process configured to produce the Min and Max Start Date grouped by Location.

Previous Step Entity Set

ProjectId

Location

Period

1

NY

1/2018

1

NY

1/2019

1

CA

1/2020

Result Entity Set

Location

Min period

Max period

NY

1/2018

1/2019

CA

1/2020

1/2020