## Data Functions

Some data elements may be represented as collections and some other functions may be needed. This is the case for Data Masters, Data Grids, Data Lists, Selection Components, etc.

##### Data selection

This function takes two input parameters A and B. Parameter A represents the data collection where the selection will be applied to (eg: Data Master), and parameter B works as a selection filter represented by a Data Master's attribute. Hence, this function will return the filtered data from A following B rules. The result will be generally a list of values.

##### Filter

This function takes two input parameters A and B. Parameter A represents the data collection where the filter is applied to (eg: Data Master), and parameter B represents the filter condition. Parameter B is usually a conditional expression made of Data Master's attributes and conditional operators. Hence, this function will return a list of Data Master's instances following B rules.

##### Select Distinct

This function works as 'Data selection' returning the same list of values but repeated items.

##### Filter Distinct

This function works as 'Select Distinct' but returning a list of Data Master's instances instead of a list of values

##### Count

This function returns the number of data instances the input collection has.

##### Summation

This function returns the summation of an input data list. The function needs two parameters A and B: parameter A represents a data collection and B acts as a filter of A as the 'Data Selection' operation does. Moreover, parameter B may contain number operators. The filtered data collection must consist of numbers for the operation to work properly.

##### Average

This function returns the mean from a data set by dividing the sum of data by the number of items in the data set. The input parameters are the same as for the Summation operation.

##### Maximum

This function takes the same parameters as Summation. In this case, it will return the maximum number found in the input data set.

##### Minimum

This function takes the same parameters as Summation. In this case, it will return the minimum number found in the input data set.

##### Concatenate

This function represents the concatenation of two data collections. It takes two input parameters each one representing a data collection and returns a list containing both sets.

##### Substract

This function takes two input parameters A and B, each one representing a data collection. It returns a list containing all the items from data set A which do not appear in B.

##### Sort

This function takes two input parameters A and B. Parameter A represents the data collection which will be sorted (eg: Data Master), and parameter B is an attribute from the datasource which acts as the category to sort. This function will return the same data from parameter A sorted by attribute B.
Also, there is a dropdown indicating the order the sort must take: ascending or descending. This will order the data in parameter A in one way or another, for numbers, texts or even dates.