Difference between revisions of "Function"
(Created page with "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; ** Co...") |
|||
| Line 4: | Line 4: | ||
'''Options''' | '''Options''' | ||
| − | + | '''For [[Value]] data type:''' | |
| − | + | * Sum: Show the sum of the values; | |
| − | + | * AVG: Show the average of the values; | |
| − | + | * Count: Show the count (ammount of occurences) 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 (ammount of occurences) of the data; | |
| − | + | * Count Distinct: Show the count distinct (ammount of unique occurences) of the data; | |
| − | + | * Max: Show the alphabetical last text or the last date; | |
| − | + | * Min: Show the alphabetical first text or the first date; | |
Revision as of 14:41, 15 April 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 (ammount of occurences) 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 (ammount of occurences) of the data;
- Count Distinct: Show the count distinct (ammount of unique occurences) of the data;
- Max: Show the alphabetical last text or the last date;
- Min: Show the alphabetical first text or the first date;
Applies to
