Difference between revisions of "Function"
Line 1: | Line 1: | ||
+ | <translate> | ||
Specifies the function to be used in the column. | Specifies the function to be used in the column. | ||
Line 20: | Line 21: | ||
* '''Max''': Show the alphabetical last text or the last date; | * '''Max''': Show the alphabetical last text or the last date; | ||
* '''Min''': Show the alphabetical first text or the first date; | * '''Min''': Show the alphabetical first text or the first date; | ||
+ | </translate> |
Revision as of 13:40, 2 April 2014
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.
- 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;