...
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.
Creation
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
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.
...
Figure 1. Prompt to save changes in cell editor before open the table editor
Dimensions
The dimension settings feature all the settings associated with the handling and rendering of the table’s dimensions
Show at
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
Show header
Shows, if checked, the dimension name in its table column.
Alignment
Choose the alignment of the dimension elements. Possible alignments:
Vertically: Top/Bottom
- Horizontally: Left/Middle/Right
Repeat notation
Repeats, if checked, the table column header notation in the table footer.
Measures
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.
Type
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.
Notation
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.
Concept
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.
Axis mid
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.
...
Define a list of conditions to show or hide specific values according to your definitions.
Type
Determine how the values should be displayed.
...
(only when stack is active) Display the percentage of the value in proportion to the sum of all measures in all dimensions.
Background
Determine the background of a value.
...
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 middle of the first element.
Outlier
Outliers are values that are larger than the other values of a measure. TRUECHART can display these outliers so that the chart is readable.
Operator/Value
Every value of a measure is checked to this condition and when the condition is true the value is displayed as an outlier.
Show as
Determine how the value of the outlier should be displayed.
...
Instead of the original value, a symbol is displayed at the position of the outlier.
Symbol
Determine the position of the outlier and the outlier symbol.
Style
Determine where the value and where the outlier symbol is displayed.
...
Outlier symbol at the axis and value at the original value position of the outlier.
Scaling helper
Add or remove a scaling helper. A scaling helper helps to visualize the scaling of a chart.
...
Figure 4. Chart with Scaling Helper.
Maximize
Actives, if checked the scaling helper visualization.
Show
Determine if a value should be displayed on the scaling helper and the position of the value.
...
Value at the end of the scaling helper.
Displace
Determine if the value should be moved, when intersecting with another value occurs.
...
The value is moved horizontally from its original position.
Sign
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.
| Info |
|---|
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. |
Freeze table headers
In its normal state, the headers will scroll with the data causing the headers to disappear.
This is how you would freeze your table headers while scrolling through your data:
- Right click on your table and select "Grid".
...