Table (Legacy) visualization

Customize and edit a Table (Legacy) chart visualization type.

The following options are available under each tab.

Tip: Customize and edit the selected visualization type in the Edit Tile dialog box by clicking Edit.

Plot

The following options are available in the Plot tab.

Note: To enable Show Totals or Show Row Totals in the Plot tab, Totals and Row Totals need to be selected respectively, in the Data table.
Options Description
Table Theme Changes the theme colors of the overall table.
Show Row Numbers Assigns each row a value starting from 1 in the table.
Hide Totals Hides the total for each column at the bottom of the table.
Hide Row Totals Hides the total for each row at the right of the table.
Limit Displayed Rows Allows you to either Hide or Show a selected number of rows starting from the First row or the Last row.

Series

The following options are available to customize the whole table:

Options Description
Truncate Text Truncates text from columns.
Show Full Field Name Shows the name of the data source and the dimension.

For example, the data source is in profile variables and the dimensions chosen is Count. When it is toggled on, it is displayed as "Profile Variable Count".

Customization section displays each dimension or measure selected and allows you to customize the:

Icon Fields Description
Label Label displayed on the table.

Formatting

Note: Toggle Enable Conditional Formatting to display all the options in this tab.
Sections Options Description
Include Totals Rules are applied to totals displayed in the table.
Include null values as Zero Null values are represented as a zero.
Colors Collection Select from a group of pre-selected colors.
Rules Add Adds a rule.
Remove Removes a rule.
Apply to Select whether it will apply to either all numeric fields or a selected measure.
Format Specifies which numeric values the rule will apply to.

Additional fields can differ between values selected. The following Format fields can customize the Background color, Font color, or Font style:

  • equal to
  • not equal to
  • greater than
  • less than
  • between
  • not between
  • null
  • not null

The along the scale Format option allows you use the following options:

  • Palette
  • Reverse colors
  • Use color steps
  • Mirror range around center value
Background color Color of the background of the values.
Font color Color of the values.
Font style Bold, italicize, or strikethrough the values.
Palette

Choose one of several existing palettes or create a custom palette in the Custom tab. The following options are available:

  • Type in a hex code or click Edit All to edit all hex codes at once.
  • Click the Color Wheel button and click into the color wheel to select a color.
  • The color's brightness can be adjusted with the slider at the bottom.
  • Click the Add or Remove buttons to add or remove more colors in the color range.
Note:
  • Minimum number of colors in a palette is two.
  • Maximum number of colors in a palette is five.
Reverse colors Apply colors at the:
  • Left end of palette to higher values in the data range
  • Right end of the palette to lower values in the data range
Use X color steps Limits the number of colors used in the palette to the specified step value. When the option is:
  • Enabled: Data is grouped and colored according to the number of color steps.
  • Disabled: Colors are picked using the gradient of the palette's spectrum.

For example, if you specify 2 color steps, the data is grouped into 2 groups and only 2 colors will be displayed on the table.

Note: You can insert numbers from 2 to 100 in the color step.
Mirror range around center value Make equal color shifts on either side of the color palette. For example, on a scale from -100 to 0 to 100, values -20 and 20 will be the same color distance.
Range Specify the values that determine the palette gradient start (0%), center (50%), and end (100%) colors.