TRUECHART Knowledge Base Live Search
This article covers the legacy table that was developed prior to version 2020.2. With version 2020.2 the Table 2.0 got introduced to TRUECHART (see Table 2.0).
TRUECHART supports table visualizations for normally structured table views and also for inline commenting purposes. Tables can represent various visualizations in its columns like values, bars, waterfall, lines, needles, comments (texts, lists and flags) and many more.
Table visualization can be created on initial TRUECHART objects or in a grid cell you like by selecting Table below the chart or commenting section from the cell type selector on an initial cell or in the settings editor.
The table elements will be disabled unless at least one dimension and one measure are available for the TRUECHART object.
Chart Settings are split into several topics. You can navigate to each topic with the navigation menu. The specific settings for charts are:
Context Selector if multiple contexts are defined,
1. Table layout
- 2. Define dimension settings
- 3. Table definition
- 4. Comment settings when a comment type is defined for the table (only for old table)
Configure comment measures
TRUECHART will gradually be converted to a completely new user interface starting with version 2018.9, with the aim of achieving a significant simplification for the user. Since this development has not yet been completed, some configuration areas are still available in their original form and are therefore integrated separately into the new user interface.
Therefore the comment configuration can be opened by clicking on the comment entry in the navigation menu on the left. The cell editor has then closed automatically and the comment settings dialog opened. If changes have already been made by the user in the Cell Editor, the following prompt is displayed before closing.
The comment entry is only available when there is a comment measure active in the table!
Figure 1. Prompt to save changes in cell editor before open the table editor
The dimension settings feature all the settings associated with the handling and rendering of the table’s dimensions
Defines the position of the Dimension. You have the following options:
-: Hides the Dimension entities
Axis: Shows all Dimension elements below the Chart
Free Axis Position Dimension entities showed at free position
Shows, if checked, the dimension name in its table column.
Choose the alignment of the dimension elements. Possible alignments:
- Horizontally: Left/Middle/Right
Repeats, if checked, the table column header notation in the table footer.
The measure settings feature a list of all the measures available in the defined data context. To edit a measure just click on the measure in the measure list at the top. Clicking on the button on the right side it is possible to jump to Measure settings of the corresponding measure.
The drop-downs contains all the applicable measure visualizations, i.e. Value, Bar, Needle, Waterfall, Line, and Symbol, as indicated by following illustration:
Additionally, there is "None" to disable the visualization of the particular measure at all as well as List, Comment and Flag to define input fields in tables.
Show as values
No functionality for tables.
The Notation list provides different ways of displaying the measure’s meaning, specified in its data rules. Depending on the type of measure visualization, you can apply the meaning to:
ElementThe visualization concept of the base datatype affects the element, e.g. a bar. The header visualization concept of the base datatype affects the header of the table.
The Concept list is used to define one of the visualization concepts Area and Color, dependent on the time type and the scenario (actual, budget, forecast) in the notation manual.
In table visualizations, the Axis mid option will force the axis of graphical representation to be centered in the column instead of automatically adjusted based on the min-max span.
Values - Show
Determine if you want to show all values, none of them, the smallest and largest value or selected values, according to a predefined logic.
Hide all values of the measure.
Show all values of the measure.
Suppress null values.
Show only the min and max value.
Define a list of conditions to show or hide specific values according to your definitions.
Determine how the values should be displayed.
This is the default and resembles the current value during runtime.
Display the percentage of the value in proportion to the sum of all values of the measure.
(only when stack is active) Display the percentage of the value in proportion to sum of all stacked values in the dimension.
(only when stack is active) Display the percentage of the value in proportion to the sum of all measures in all dimensions.
Determine the background of a value.
No background displayed.
A white, lightly transparent background. (default)
The font color is black or white, according to the underlying color.
Legend/Header - Show
Determine if the legend and header should not be displayed or at a specific position.
The legend is drawn on the same level as the first value position, that is different from zero
The legend is drawn on the level of the axis.
The legend is drawn on the middle of the first element.
Outliers are values that are larger than the other values of a measure. TRUECHART can display these outliers so that the chart is readable.
Every value of a measure is checked to this condition and when the condition is true the value is displayed as an outlier.
Determine how the value of the outlier should be displayed.
No value is displayed.
The original value is displayed.
Instead of the original value, a symbol is displayed at the position of the outlier.
Determine the position of the outlier and the outlier symbol.
Determine where the value and where the outlier symbol is displayed.
Symbol at value position, value at the axis
Outlier symbol at the original value position of the outlier and value at the axis.
Symbol at the axis, value at value position
Outlier symbol at the axis and value at the original value position of the outlier.
Add or remove a scaling helper. A scaling helper helps to visualize the scaling of a chart.
Figure 4. Chart with Scaling Helper.
Actives, if checked the scaling helper visualization.
Determine if a value should be displayed on the scaling helper and the position of the value.
No value is displayed.
Value at the start of the scaling helper.
Value at the end of the scaling helper.
Determine if the value should be moved, when intersecting with another value occurs.
The value is moved vertically from its original position.
The value is moved horizontally from its original position.
When activated shows a sign at the value of the scaling helper.
Figure 5. Chart with Sign at the Scaling Helper.
Autolinking of tables columns
If there are multiple tables within one grid, TRUECHART optimizes both tables in a way that the width of each column will be the same.
If you would like to avoid scrollbars resulting from this behavior, you can create a one by one grid in your grid and place the table inside that newly created grid.