Difference between revisions of "Function"

From TaticView
Jump to: navigation, search
(Marked this version for translation)
 
(3 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
<languages/>
 +
 +
 
<translate>
 
<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 14: 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 21: 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>
 
</translate>

Latest revision as of 17:03, 16 November 2020

Other languages:
English • ‎português do Brasil


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;


Important: the functions mentioned above ignore null values, this means that for instance, Count("Client Name") will ignore ocurrences that "Client Name" is null.