Element Details: Formatted+Column
 Back


Available in: Logi Info Source code name: FormattedColumn

FormattedColumn adds a new column to the DataLayer that represents the formatted value.

Element Group:Add and Replace Columns



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.
Format
UserDefined
(Required) Allows a string to be formatted in various ways, especially for numeric and date values. Specifies formatting characteristics for the data. This attribute has been borrowed from the Microsoft Visual Basic Format function. For more information: http://msdn.microsoft.com/en-us/library/59bz1f0h(VS.71).aspx For dates, the non-specific formats, such as "General Date", "Short Time", etc., are converted according to the browser's international setttings. Also, for very large reports, the non-specific formats perform better. There are also some special formats. "<" and ">" change strings to lower and upper case. "Expanded Spaces" preserves space characters that would otherwise be collapsed by the web browser. "HTML" preserves HTML tags so that they are not encoded - they are embedded rather than shown. "Preserve Line Feeds" preserves line feed and cariage return characters so that the following characters appear on a new line. "mp" formats numbers with the "metric prefix". To format 1,234,567 as "$1.23M", use Format "$#.00mp". Supported metric prefixes are from 1000^6 to 1000^-6 For more information: http://en.wikipedia.org/wiki/Metric_prefix "mpsx" formats the value with x number of significant figures in addition to the metric prefix. So a value of 123456, with format set to mps3 will return 123k. "qq" returns the number of the quarter when the value being formatted represents a date. To return the year and quarter together like "2010 Q1", set the format to "yyyy Qqq". "fyy" and "fyyyy" return the fiscal year. "fqq" returns the fiscal quarter. The fiscal year start date may be configured in the settings' Globalization element. "ww" returns the number of the week. The first day of the week may be configured in the settings' Globalization element.
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.ActiveSQL
DataLayer.Bookmarks
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.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