Element Details: Crosstab+Comparison
 Back


Available in: Logi Info Source code name: CrosstabComparisonIntroduced in: v10.0.299

The CrosstabComparison makes it easy to visually understand the differences between values in crosstab columns. Each column is compared with the previous column and an arrow indicator or color background shows if the value went up or down. The amount of increase or decrease can be displayed as a percentage and/or value difference.

The ComparisonStyle attribute sets if visual differences are shown with arrows, background colors or neither.

The ComparisonShowValues attribute sets if differences are shown numerically in the crosstab cells.

The ComparisonShowTooltips attribute enables display of tooltip panels with value and percentage differences when the mouse is hovered over crosstab cells.

The Format attribute sets the format for difference values. When not set, the CrosstabTableValueColumns element is searched for a Format attribute.

Use the color attributes to set the range of background colors when ComparisonStyle=”ColorSpectrum”. The color attributes are not used with ComparisonStyle="Arrows". The color attributes are not used with the AnalysisGrid.

When sorting with CrosstabComparisons, the first column sorts by the value in the column. Other crosstab columns will sort based on the percentage difference compared to the previous column.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
ComparisonShowTooltips
Value
Percent
None
All
The ComparisonShowTooltips attribute enables display of tooltip panels with value and percentage differences when the mouse is hovered over crosstab cells. The default value is “None”.
ComparisonShowValues
Value
Percent
None
All
The ComparisonShowValues attribute sets if differences are shown numerically in the crosstab cells. “Percent” shows percentage differences. “Value” shows the difference in the two values. These differences can be displayed according to the Format attribute. The default value is “None”.
ComparisonStyle
None
ColorSpectrum
Arrows
The ComparisonStyle attribute sets if visual differences are shown with arrows, background colors or neither. The default value is “Arrows”.
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.
HighValueColor
UserDefined
The color used for the highest values of the data set. The default is green.
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.
LowValueColor
UserDefined
The color used for the lowest values of the data set. The default is red.
MediumValueColor
UserDefined
The color used for values that are in the middle of the data set. For CellColorSliders, the default is yellow. Otherwise, the default is the color between the LowValueColor and HighValueColor.
TemplateModifierFile
UserDefined
Some elements employ a definition file as a template. The definition contains language and culture specific Caption attributes that you may want to change. Or you may simply want to change the captions to better suit your application. The TemplateModifierFile is an XML file with elements pointing to other elements in the template to be changed. All other attributes get applied in the template. For example, the Dashboard2 element has a template file (rdTemplate\rdDashboard\rdDashboard2Template.lgx) several Label elements. One has an ID="lblAddPanelsTitle". The Caption can be changed with the following XML in the TemplateModifierFile: You can set attributes for any number of elements. Examine the template file to learn the ID and Caption attributes you may want to modify. The above example shows how to identify template elements with an ID attribute. Alternatively, you can also identify elements with an XPath expression. In this example, we change an attribute of the InteractivePaging element: For a more detailed list of modifier actions see the following DevNet article. TemplateModifierFiles can be in any folder accessable to the web application. When a directory location is not specified, the default location is the _SupportFiles folder.



PARENT ELEMENTS

Click element to drill down for more information.

Analysis Grid Crosstab Table


CHILD ELEMENTS

Click element to drill down for more information.



 Back to top


 Chart Debug