Display (tables)

Display

Left Padding In Em

Sets the width (in em) used to indent a hierarchy level.

Fixed Column Width

If the checkmark is set, then the mode for determining the column width is "Fixed", otherwise "Auto".

• Auto: If the Auto mode is activated, the existing space (width of the component) is evenly divided into the columns.
• Fixed: Use the Column Width option to specify a fixed width (in px) of the data columns.

Column Width (in Px)

See Fixed Column Width, Modus Fixed.

Apply Data Types To Cells, Show Data Types In Header

Enables the Data Types bars in column headers (Data Types in Header) and applies the Data Types color to each data cell (Apply Data Types To Cells).The latter exceeds all other color settings.

Table Header Position Fixed

If the column titles should be permanently visible, even if scrolled, this can be set here.

Show Filter Helper

Filter String

By specifying a filter string at this point, an initial filter can be set and applied. (Also in Java mode!)

Width Per Column

Enter here the width of each column, separated with ',' (for example: 100,200,100,200).

Column Order

If the series and deviations should appear in a different order than the default, this setting allows you to rearrange the columns. To do so, the new order must be specified in the following form (example):

series1,deviation0,series2,series3,deviation1

Visible Series

So that only certain series are visible, you can use this setting to set which series should be visible. To do this, the indices of the corresponding series are separated by comma, for example:

0,1,3

Note that the indexing begins with 0 in this case.

Calculate Sums

By activating this option, totals are automatically calculated and the totals are transferred to the chart.

Custom CSS

At this point, you can specify any CSS string, which is then applied to the visualization.

Hierarchy

Hierarchy Indent

Determines how far the individual hierarchy levels should be moved to the previous stage in em.

Show Hierarchy

Select the hierarchical representation of the dimension using the checkbox in front of Show Hierarchy.

Collapsible Hierarchy

If you want the hierarchy to be able to be opened and closed during the runtime in the dashboard, set the checkmark to Collapsible Hierarchy.

Node Style Bold, Italic und Color

Here, you control the color and font of the hierarchy nodes in the table. The color overwrites the font color set in Text Color.

Expand To

Determines to which hierarchical level the hierarchy is to be displayed expanded at the beginning (starting with level 0).

Use Hierarchy Marker

You can open a hierarchy node using the hierarchy markers (+ / -). If this option is set to false, it is also possible to open and close hierarchy nodes by clicking on the line title.

Row Order

This setting allows you to change whether the totals are displayed before or after the elements from which the totals are created.

Scaling

Sacle Mode

Choose between Automatic or Manual.

Manual Scale Max, Manual Scale Min, Manual Scale Percent Max, Manual Scale Percent Min

Define the value ranges by filling in own values.