About: This article introduces the Group By node, an Output node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Group By node is used to designate how outputs should be grouped for easy to follow reports. This is a valuable node when a project requires both a combination of data aggregation and style formatting.
A Group By node usually requires an Aggregate node to precede it. With an Aggregate node in place ahead of it, data can be arranged and summarized before it is grouped. Classifying variables and aggregate statistics will be listed on the left side of the Group By node interface. Usually, categorical fields of data would be used to Group By while aggregated values would be used as Data Columns.
In the bottom example, a report is being made which takes the Average Monthly Income of individuals (aggregated prior) and groups that figure by Job Role and Job Level. The final report consists of a group of categorical variables and their associated aggregated statistics. This is one simple example of a common use for the Group By node.
Note: Report stylizing is maintained in the Report node.
Note: Regardless of their original column types, all data emerging from this node is converted to type Text. Because of this, care should be taken when using the output of this task.
Video Tutorial
Comments
0 comments
Article is closed for comments.