Adding dynamic items to a graphical table

A graphical table can be configured to show columns with dynamic items such as sparklines, calculated values, conditional icons, or bullet graphs.

About this task

Note: In the web client, you cannot create a new graphical table visualization. You can only configure an existing one that has been created using the installed client.

Procedure

Create or click to activate a graphical table.
In the visualization properties panel, click next to the title of the graphical table.

Tip: In the installed client, you can also add a new column by right-clicking the graphical table and selecting the type of dynamic item you want to add from the Add submenu, or add items on the Axes page of the visualization properties dialog.
From the pop-up menu, select the type of dynamic item you want to add in a new column: Sparkline, Calculated value, Icon, or Bullet graph.
In the visualization properties panel, below the visualization title, make sure the dynamic item you want to adjust is selected.
The panel now only shows settings that are applicable to the selected item. You can also click to add and configure more properties.

Make the necessary changes to the settings. See below for specific settings for each of the dynamic items.

Option	Description
Sparkline	In the X-axis and the Y-axis sections, select the columns, hierarchies, or expressions to define the axes. Tip: In the installed client, you can also right-click the sparkline column and select Sparkline settings > Axes. You can adjust the scale settings for the Y-axis if needed, and show the starting point/end point values, if you want to. Depending on your data, you might also be able to change additional axis settings.
Calculated value	In the installed client, right-click the new column, and select Calculated value settings from the pop-up menu. On the Values page, select a column, hierarchy, or expression in the Calculate values using field. If you want to, add rules to provide additional information.
Icon	In the installed client, right-click the new column, and select Icon settings from the pop-up menu. On the Icons page, select a column, hierarchy, or expression in the Calculate icons using field. Add rules to define when a row should show a certain icon, or a certain color.
Bullet graph	In the installed client, right-click the new column, and select Bullet graph settings from the pop-up menu. On the Bullet graphs page, select a column or expression in the Calculate values using field. This is the horizontal bar in the bullet graph. Select a column or expression in the Calculate comparative values using field. If you do not want to use a comparative value, select Remove in the column selector. This is the vertical line in the bullet graph, sometimes also referred to as the target value. If desired, change the Color of the bar and/or vertical line. You can also add color ranges.

To change the name of the dynamic item to something that describes the dynamic item column content, click and select Rename column. You can also hide the column name or the entire header row of the graphical table.

Tip: In the installed client, you can also configure these settings under General and Appearance.
If you want, make other changes to the default settings, such as changing the filtering scheme under Data, adding an action, displaying starting point and end point Y-axis values (sparkline), setting up a rule (calculated value or icon), or adding color ranges (bullet graph).

Changing the column order

Click a column header and drag that column to the desired position. Note that the row header column cannot be moved.

In the installed client, you can also right-click a column header and select Move first or Move last from the pop-up menu, or move items in the list on the Axes page of the visualization properties dialog.

Removing a column from a graphical table

You can remove dynamic items in the visualization properties, see Removing a dynamic item from a graphical table for details.