About: This article introduces the Median node, a Compile node within Construct.
Location: Node panel
Table of Contents
Feature Overview
The Median node creates a special aggregate of the source data. A column placed in the Median Columns list will be used to create a new variable that displays the median value of that column using all incoming records. The output data will consist only of these new variables.
Columns placed in the Median By Columns list will also appear in the output. Together, these columns determine how many records appear in the output. In effect, one data record will be output for each unique combination of values found in the columns listed in this section.
In the example shown, the two SAT scores are being aggregated to find their median values. Because these scores are being aggregated by Gender, one record of median SAT scores will appear for each unique value of gender found in the incoming data.
Comments
0 comments
Article is closed for comments.