Savant

Calculates the average value of a specified numeric field across a range or partition

Combines unique text values from multiple rows in a specified field into a single text value

CONCAT

Counts the number of rows within a specified range or partition

Counts the number of unique values in a specified field within a range or partition

Calculates the cumulative sum of a specified numeric field across a range or partition

Populates missing values in a specified field using a defined strategy, such as forward fill or backward fill

Get the first value of a specified field within a range or partition

Get the value of a specified field from a previous row in the dataset

Get the last value of a specified field within a range or partition

Get the value of a specified field from a subsequent row in the dataset.

Get the maximum value of a specified field within a range or partition

Get the median value of a specified numeric field within a range or partition

Get the minimum value of a specified field within a range or partition

Assigns a bucket number to each row in a partition

Assigns a rank to each row within a partition of the dataset, with ties receiving the same rank

Calculates the standard deviation of a specified numeric field within a range or partition

Calculates the total sum of a specified numeric field within a range or partition

Calculates the variance of a specified numeric field within a range or partition.

Find answers and get help from Intercom Support and Community Experts

Track the progress of all tickets related to your company.

{assigneeName} needs more information from you