Element Details: Chart+Grid+Column
 Back


Available in: Logi Info Source code name: ChartGridColumnIntroduced in: v10.0.189

Chart Grid Columns define the data columns that may be displayed and manipulated in the Chart Grid.

The DataType attribute effects how columns are presented in the grid.

Text columns are available in the Columns, Rows and X axis panels, and they presented with bar charts when selected for the X axis.

Number columns are available in the X and Y axis panels, and they are presented with line and scatter charts when selected for the X axis.

Date columns are available in the X axis panel and they are presented with line and scatter charts when selected.

Formatting for data values can be specified in different ways for different parts of the ChartGrid.
- To format values for the grid's row and column headers, use the Format attribute.
- To format values for the charts' X axis, add a FormatLabel element.
- Y axis formats are done with FormatData elements.

Hint: To create bar charts with dates, use the TimePeriodColumn under the DataLayer and set the DataType="Text". Then set the Format to show only a portion of the date, like Format="yyyy MM", and add a FormatLabel with ChartDateFormat="yyyy mm".



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
Caption
UserDefined
(Required) The Caption attribute identifies the text to be displayed. For Image elements, Caption specifies the image filename.
DataColumn
UserDefined
(Required) The name of a data field/column returned from the DataLayer.
DataType
Text
Number
Date
(Required) Specifies the type of data present.
Format
UserDefined
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.
SecurityRightID
UserDefined
When entered, access to this element can be controlled with Logi security. Supply the ID of a right defined in the applications settings’ Security element. Only users that have a right in the SecurityRightID will be able to see the element. Note that when rights come from RightFromRole elements under Security/UserRights, and this element's SecurityRightID does NOT match any of the Right IDs defined in the Settings definition, then the user DOES have access. But when Right IDs are instead derived from RightsFromDataLayer or RightsFromRoles elements, and the user DOES NOT have a matching Right, then the user DOES NOT have access. You can enter multiple right IDs, separated by commas. In this case, the user sees the element if he has any one of the Rights.



PARENT ELEMENTS

Click element to drill down for more information.

Chart Grid


CHILD ELEMENTS

Click element to drill down for more information.

Format Label


 Back to top


 Chart Debug