Element Details: Aggregate+Column
 Back


Available in: Logi Info Source code name: AggregateColumn

An AggregateColumn adds a new column in the DataLayer that represents an aggregate value of all rows of the DataLayer.

The column can be used like any other column. The value is populated in every row so that it can be used in further calculations, SummaryRows, LinkParams, etc. It is also populated in the top-level row, allowing reference to the value anywhere in the report outside of a DataTable.

Set the ID to the name of the new column.

Set the AggregateFunction attribute to the type of aggregate desired; Sum, Count, Average, Min, Max, or Concat.

The default DataType is "Number". The DataType must be "Number" for the Sum and Average functions. By default, non numeric rows in "Number" columns will be disregarded for function calculations. That is, a data row whose value is "abc" or " " will not be included in the Count function.

Element Group:Add and Replace Columns



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
AggregateColumn
UserDefined
(Required) The column (field name) that is being aggregated. For COUNT, you can specify any column name. Other aggregate functions require a numeric column.
AggregateFunction
Sum
Stdev
Mode
Min
Median
Max
DistinctCount
Count
Concat
Average
(Required) Aggregate function sets the function for the aggregation.
ConcatSeparator
UserDefined
The character used to separate concatenated text values. Defaults to a comma.
DataType
Text
Number
Date
Specifies the type of data present.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
IncludeCondition
True
False
An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Cached
DataLayer.CSV
DataLayer.Definition List
DataLayer.Directory
DataLayer.ETL
DataLayer.Excel
DataLayer.Fixed Format File
DataLayer.Google App
DataLayer.Google Spreadsheet
DataLayer.GPX File
DataLayer.JSON
DataLayer.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Plugin
DataLayer.REST
DataLayer.Scheduler
DataLayer.SimpleDB
DataLayer.SP
DataLayer.SQL
DataLayer.Static
DataLayer.Twitter
DataLayer.Web Feed
DataLayer.Web Scraper
DataLayer.Web Service
DataLayer.XML


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug