Difference between revisions of "Function"
| Line 6: | Line 6: | ||
'''For [[Value]] data type:''' | '''For [[Value]] data type:''' | ||
| − | * 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; |
| − | * Count: Show the count ( | + | * '''Count''': Show the count (amount of occurrences) of the values; |
| − | * Max: Show the higher value; | + | * '''Max''': Show the higher value; |
| − | * Min: Show the smaller value. | + | * '''Min''': Show the smaller value. |
'''For [[Date]] and [[Text]] data types:''' | '''For [[Date]] and [[Text]] data types:''' | ||
| − | * None: No function will be applied, show the actual data. | + | * '''None''': No function will be applied, show the actual data. |
| − | * Count: Show the count ( | + | * '''Count''': Show the count (amount of occurrences) of the data; |
| − | * Count Distinct: Show the count distinct ( | + | * '''Count Distinct''': Show the count distinct (amount of unique occurrences) of the data; |
| − | * 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; |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 19:19, 13 May 2013
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;
