View source for Function/en

<languages/>


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.