In Brief

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

Case Study

Using the bond prices data set, we would like to figure out how often each Ticker appears in the data set.

Workflow

Workflow for Frequency Table

Input data:

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

Options

Once the data is connected, we can configure it.

Fields: Select here the fields for which you want to count frequencies.

Sort by frequency: Choose whether the output data should be sorted.

Output

We are only interested in the names, so we only select “Ticker” from the list of fields. Running the workflow produces the following output: