Element Details: Time+Period+Column
 Back


Available in: Logi Info Source code name: TimePeriodColumnIntroduced in: v9.0.30

A Time Period Column adds a new column in the DataLayer that represents a time period such as year, quarter, month, week, etc. The column can be used like any other column.

Set the ID attribute to the name of the new column.

Set the DataColumn attribute to the name of a column has a date value.

Time Period Columns can be culture-aware. This can change the text returned with the periods that return names and abbreviations. And the day of the week number can be different for different cultures too. Set the TimePeriodCulture to a specific culture value or get the client browser's culture with "@Function.UserCulture~". The default TimePeriodCulture is the "invariant" culture, which is basically US English.

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.
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"
TimePeriod
Year
Week
Second
Quarter
MonthName
MonthAbbreviation
Month
Minute
LastDayOfYear
LastDayOfWeek
LastDayOfQuarter
LastDayOfMonth
LastDayOfFiscalYear
LastDayOfFiscalQuarter
Hour
FiscalYear
FiscalQuarter
FirstSecondOfMinute
FirstMinuteOfHour
FirstMillisecondOfSecond
FirstHourOfDay
FirstDayOfYear
FirstDayOfWeek
FirstDayOfQuarter
FirstDayOfMonth
FirstDayOfFiscalYear
FirstDayOfFiscalQuarter
DayOfYear
DayOfWeekName
DayOfWeekAbbreviation
DayOfWeek
DayOfMonth
Date
(Required) The time period.
TimePeriodCulture
UserDefined
Time Period Columns can be culture-aware. This can change the text returned with the periods that return names and abbreviations. And the day of the week number can be different for different cultures too. Set the TimePeriodCulture to a specific culture value or get the client browser's culture with "@Function.UserCulture~". The default TimePeriodCulture is the "invariant" culture, which is basically US English.



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.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