Difference between revisions of "Function"
(Marked this version for translation) |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | <languages/> | ||
| + | |||
| + | |||
| + | <translate> | ||
| + | <!--T:1--> | ||
Specifies the function to be used in the column. | Specifies the function to be used in the column. | ||
| + | <!--T:2--> | ||
'''Options''' | '''Options''' | ||
| + | <!--T:3--> | ||
'''For [[Value]] data type:''' | '''For [[Value]] data type:''' | ||
| + | <!--T:4--> | ||
* '''Sum''': Show the sum of the values; | * '''Sum''': Show the sum of the values; | ||
* '''AVG''': Show the average of the values; | * '''AVG''': Show the average of the values; | ||
| Line 13: | Line 21: | ||
| + | <!--T:5--> | ||
'''For [[Date]] and [[Text]] data types:''' | '''For [[Date]] and [[Text]] data types:''' | ||
| + | <!--T:6--> | ||
* '''None''': No function will be applied, show the actual data. | * '''None''': No function will be applied, show the actual data. | ||
* '''Count''': Show the count (amount of occurrences) of the data; | * '''Count''': Show the count (amount of occurrences) of the data; | ||
| Line 20: | Line 30: | ||
* '''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; | ||
| + | |||
| + | |||
| + | <!--T:7--> | ||
| + | '''Important''': the functions mentioned above ignore null values, this means that for instance, Count("Client Name") will ignore ocurrences that "Client Name" is null. | ||
| + | |||
| + | </translate> | ||
Latest revision as of 17:03, 16 November 2020
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;
Important: the functions mentioned above ignore null values, this means that for instance, Count("Client Name") will ignore ocurrences that "Client Name" is null.