About: This article introduces the Aggregate node, a Compile node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Frequency node helps to understand the counts of unique values represented in the data for any particular field. In the example below, the frequency is being determined by gender. At the bottom right of the window, you can select the Sort By and Sort Direction of the data. You can also choose the Percent's Format.
Running this to an output gives each unique value of gender, the number of times it was represented in the data, the percent (%) it amounted to, as well as the cumulative frequency and percent.
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.
The Frequency node should be connected to a Temp Report node or a Report node to best view the results.
Video Tutorial
Comments
0 comments
Article is closed for comments.