Element Details: Relevance+Filter
 Back


Available in: Logi Info Source code name: RelevanceFilter

The RelevanceFilter removes rows in which a value falls below a certain threshold. When rows are dropped out, an additional row can be added to represent them by setting the Label Column and Irrelevance Value attributes.

In a report definition, the RelevanceFilter is great for creating pie charts with an "Others" wedge.

The row has two columns - one for the label, and one for an aggregated value that is the sum of the dropped rows. Set the LabelColumn attribute to the column name that will receive the IrrelevanceLabel value. Set the DataColumn attribute to the column name that will receive the aggregate sum of irrelevant rows.

Element Group:Filter Rows



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DataColumn
UserDefined
(Required) The name of a data field/column returned from the DataLayer.
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"
IrrelevanceLabel
UserDefined
The RelevanceFilter removes rows in which a value falls below a certain threshold. When rows are dropped out, an additional row can be added to represent them. This is called an "All Others" row. The row has two columns - one for the label, and one for an aggregated value that is the sum of the dropped rows. Set the Irrelevance Label to a value such as "Other", or "All Others".
LabelColumn
UserDefined
The RelevanceFilter removes rows in which a value falls below a certain threshold. When rows are dropped out, an additional row can be added to represent them. This is called an "All Others" row. The row has two columns - one for the label and one for an aggregated value that is the sum of the dropped rows. Set the Label Column to the name of a column returned by the DataLayer that will get the IrrelevanceLabel value.
RelevanceReverse
True
False
RelevanceReverse returns the rows with the smallest values, rather than the largest. The default is "False".
RelevanceType
Value
PercentageOfValues
NumberOfRows
(Required) The RelevanceFilter removes rows in which a value falls below a certain threshold. RelevanceType sets how the threshold is determined - by the percentage of all values, by the number of rows, or by a specific value. For example, in order to drop out the bottom 5 percent of the total values, set the Relevance Type to "Percentage of Values" and the Relevance Value to "95" percent. To select just 10 rows with the highest value, set the Type to "Number of Rows", and the Value to "10". Set the Type to "Value" to throw away all rows that drop below a specific number in Value attribute.
RelevanceValue
UserDefined
(Required) The RelevanceFilter removes rows in which a value falls below a certain threshold. When rows are dropped out, an additional row can be added to represent them. RelevanceValue sets the percentage, record count, or value that determines which rows are dropped. When under certain charts, this value may be left blank and it will be determined automatically based on the size of chart. Larger charts will show more detail, more values than smaller charts.



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


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug