NOTE: All the example Questions in this page use this Example Dataset.

Functions are usually composed of the Function's name, parentheses and one or more Arguments separated by commas between the parentheses. Additionally, there can be Grouping or a Filter inside.

Arguments

Some Functions have a fixed number of Arguments. For example, the RATIO Function always takes two arguments - a dividend and a divisor.

Examples:

Some Functions have variable number of Arguments. These functions can behave differently depending on the number of Arguments used.

Examples:

Filters in Functions

You can set up a Filter inside a Function. It will filter the Data on which the computation will be performed.

Examples:

Grouping in Functions

You can do grouping within Functions using the ACROSS Keyword. Take the following example:

First, this groups the Data by each City. Then, for each of these groups, it adds the Sales values. Finally, it computes the average value of these totals.