Element Details: Group+Filter
 Back


Available in: Logi Info Source code name: GroupFilter

A Group Filter groups rows from a DataLayer, and allows aggregate values to be created. For example, suppose you have an Orders Table and you would like to list only the individual sales person associated with the orders. You would select something like EmployeeID as the grouping column. If you want to get a count of all orders for each employee, you would add a Group Aggregate Column with the function "COUNT". Alternatively, a "SUM" aggregate could provide the total sales for each employee.

Rows are grouped by values based on one or more columns of the DataLayer. Enter the grouping column name(s) in the GroupColumn attribute. Separate multiple column names with commas.

The GroupFilter can either keep just the first row from each group, or it can keep all groups. See the KeepGroupedRows attribute.

Element Group:Organize Data



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataType
Text
Number
Date
Specifies the type of data present.
GroupColumn
UserDefined
(Required) Set Group Column to the name of the column that will group all rows with the same value together. You can group by multiple columns by adding the additional column names, separated by commas.
Hierarchical
True
False
When True, changes the DataLayer into a hierarchical shape. This format is required by certain elements, including the DataTree and SubDataTable.
ID
UserDefined
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"
KeepGroupedRows
True
False
KeepGroupedRows indicates that the GroupFilter should not discard the "extra" rows that are grouped together. By default, KeepGroupedRows="False", and only the first row of each group is kept in the DataLayer. When KeepGroupedRows="True", all rows are kept. Any columns created with GroupAggregateColumn elements are added/duplicated in all the grouped rows.
SortSequence
Descending
Ascending
The Sort Sequence defines the sort direction. Defaults to Ascending.



PARENT ELEMENTS

Click element to drill down for more information.

DataLayer.Bookmarks
DataLayer.Cached
DataLayer.CSV
DataLayer.Data Services
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.KML File
DataLayer.LDAP
DataLayer.Linked
DataLayer.Mongo Find
DataLayer.Mongo Map Reduce
DataLayer.Mongo Run Command
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
Group Filter


CHILD ELEMENTS

Click element to drill down for more information.

Group Aggregate Column Group Filter


 Back to top


 Chart Debug