Miscellaneous operations

In addition to the five basic operations, you can choose to use a miscellaneous operation in the Trillion-Row Spreadsheet.

Miscellaneous operations provide additional functionality to help simplify common analytical tasks.

The following miscellaneous operations are available:
Expand rows
Choose the number of times that each row appears in the table.
Split and expand a string column on a given separator.
Find and replace one or more patterns within a string column.
Convert strings into dates, times, or intervals and format times and dates into strings.
Group Metric
Compute an aggregation, grouping by rows by one or more columns.