Difference between revisions of "Function"

From TaticView
Jump to: navigation, search
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.


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;