Contents x
    Frequency
    • 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Frequency

    • Updated on 06 Jan 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Description

    The Frequency node is used to calculate the frequency of a value conditon occuring 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

    SettingDescription\Parameters
    Split ColumnsThe selected column(s) will be used to split the data set over when calculating summary metrics.

    Column Fill Options

    SettingDescription\Parameters
    Target NameThe column containing the value you wish to check for a condition.
    Output Column PrefixThe prefix for the name of the frequency ouput column. The suffix of the output column name is determined by the Output Type
    Output TypeIndicates the frequency metric used for the output column.

    Options
    • Percentage - Calculates the percentage of occurrences of the condition being true across the Split Columns.
    • Count - Counts the number of occurrences of the condition accross the Split Columns.
    ConditionIndicates the frequency metric used for the output column.

    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 ValueWhen valid, this is the value used for the Condition setting.

    Actions

    ActionDescription
    PreviewAfter configuring the node, the combined result set can be previewed by clicking the Preview button.
    Was this article helpful?
    What's Next