Developing Apama Applications > Dashboard Function Reference > Tabular Functions > Average Columns
Average Columns
Returns a table that includes a column reflecting the average of two specified columns of a specified table, the average of a specified value and a specified column, or the average of two specified values.
Usage notes
*Case 1: Average of two specified columns of a specified table. This is the case if First Column Name or Numeric Value and Second Column Name or Numeric Value both specify a column of Table.
*Case 2: Average of a specified value and a specified column. This is the case if one of First Column Name or Numeric Value and Second Column Name or Numeric Value specifies a column of Table and the other specifies a numeric value.
*Case 3: Average of two specified values. This is the case if First Column Name or Numeric Value and Second Column Name or Numeric Value both specify a numeric value.
In case 1, the nth cell in the returned column corresponds to the nth cell of the table specified by the argument Table. Each cell of the returned column contains the result of computing the average of the corresponding row’s cell in First Column Name or Numeric Value and the cell in Second Column Name or Numeric Value.
In case 2, the nth cell in the returned column corresponds to the nth cell of the table specified by the argument Table. Each cell of the returned column contains the result of computing the average of the corresponding row’s cell in the specified column and the specified numeric value.
In case 3, each cell of the returned column contains the average of the two specified numeric values.
In the returned table, the average column is preceded by copies of all the columns in Table.
Arguments
The function has the following arguments:
*Table: Table that contains the columns to be averaged.
*First Column Name or Numeric Value: Text string specifying the first column to be included in the average, or numerical value to be included in the average.
*Second Column Name or Numeric Value: Text string specifying the second column to be included in the average, or numerical value to be included in the average.
*Result Column Name: Text string that specifies the name of the column containing the averages. You must supply a value for this argument.
This function returns a table.
Copyright © Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its Subsidiaries and or/its Affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.