2,100
edits
Changes
Created page with "Função"
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;
'''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;
