Frequency

  • Updated on Jan 13, 2023
  • Published on Sep 29, 2022
  • 1 minute(s) read
Prev Next

Description

The Frequency node calculates the frequency of a value condition occurring across rows. For example, you can calculate the number of rows that have a column containing a value greater than 1.


Configuration Options

Basic Configuration Options

Setting Description\Parameters
Split Columns The selected columns split the data set up when calculating summary metrics.

Column Fill Options

Setting Description\Parameters
Target Name The column containing the value to check for a condition.
Output Column Prefix The prefix for the name of the frequency output column. The suffix of the output column name is determined by the Output Type
Output Type Indicates the frequency metric used for the output column.

Options
  • Percentage - Calculates the percentage of occurrences of the 'true' condition across the Split Columns.
  • Count - Counts the number of occurrences of the condition across the Split Columns.
Condition Indicates the output column frequency metric.

Options
  • greater than
  • greater than or equal to
  • equal to
  • less than
  • less than or equal to
  • is empty/blank
  • is null
  • is not null
  • is not empty
  • is null or empty
  • is not null or empty
Custom Value When valid, it is used for the Condition setting.

Actions

Action Description
Preview Once the node is configured, the combined result set can be previewed at any time.