Function

Specifies the function to be used in the column.

Options

For Value data type:

• Sum: Show the sum of the values;
• AVG: Show the average of the values;
• Count: Show the count (amount of occurrences) of the values;
• Max: Show the higher value;
• Min: Show the smaller value.

For Date and Text data types:

• None: No function will be applied, show the actual data.
• Count: Show the count (amount of occurrences) of the data;
• Count Distinct: Show the count distinct (amount of unique occurrences) of the data;
• Max: Show the alphabetical last text or the last date;
• Min: Show the alphabetical first text or the first date;

Important: the functions mentioned above ignore null values, this means that for instance, Count("Client Name") will ignore ocurrences that "Client Name" is null.