Spotfire® Web Client User Guide

Adding dynamic items to a graphical table

A graphical table can be set up 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

  1. Create or click to activate a graphical table.
  2. In the visualization properties panel, click next to the title of the graphical table.
  3. 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.
    Note: 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.
  4. Below the visualization title, make sure the dynamic item you want to adjust is selected. The visualization properties panel now only shows settings that are applicable to the selected item. You can also click to add and configure more properties.
  5. Make the necessary changes to the settings. See below for specific settings for each of the dynamic items.
    OptionDescription
    Sparkline In the X-axis and the Y-axis sections, select the columns, hierarchies, or expressions to define the axes.
    Note: In the installed client, you can also right-click the sparkline column and select Sparkline settings > Axes.
    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.
    IconIn 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.
    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.

  6. 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.
  7. 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 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.

Removing a column from a graphical table

See Removing a dynamic item from a graphical table for how to remove a column.