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 (ammount of occurences) 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 (ammount of occurences) of the data;
  • Count Distinct: Show the count distinct (ammount of unique occurences) of the data;
  • Max: Show the alphabetical last text or the last date;
  • Min: Show the alphabetical first text or the first date;

Applies to

Column