Function: Provides the frequency of observations across specified fields
Typical Use Case: If a user had a large number of fields and wanted to find the number of occurrences of specific subsets
Using the bond prices data set, we would like to figure out how often each Ticker appears in the data set.
Workflow for Frequency Table
For this example, the input data consists of bond names and various other fields specifying bond properties.
Example bond prices input data for Frequency Table
Once the data is connected, we can configure it.
Options for Frequency Table
Fields: Select here the fields for which you want to count frequencies.
Sort by frequency: Choose whether the output data should be sorted.
We are only interested in the names, so we only select “Ticker” from the list of fields. Running the workflow produces the following output:
Example Output for Frequency Table