Table visualization (SmartViz)

Important

This feature is in beta and subject to change. Reach out to support with any issues.

The Table visualization shows your data in a tabular format. Unlike the classic table, each column in a SmartViz table uses a Renderer that controls how its values are drawn: as plain text, formatted numbers, colored badges, progress bars, links, or tags.

Note

The Table visualization doesn't use the Data mapping section. Configure the columns in the Columns section instead.

When to use a table

Reach for a table when the reader needs actual values, or when rows carry more detail than a chart can encode. Lists of things are usually tables: ServiceNow Incidents - Active, GitHub Pull Requests, Azure Alerts.

What lifts the SmartViz table above a data dump is the per-column Renderer. Draw a numeric column as a Progress bar, a state column as a Status indicator, a change as a Delta, and a URL as a Link. The result reads like a dashboard rather than a spreadsheet.

Tables hold up to 12 columns. Wanting more is usually a sign the tile is answering more than one question. Every table also has a built-in filter: click the search icon in the tile's toolbar to filter all columns at once.

Try it out

Change the settings below and see how the chart updates. Select a dataset from the dropdown to see different use cases.

Interactive example
Showing

Six tickets covering every rich column type: badge, status, tags, boolean, date and link. Turning rich columns off shows the raw values underneath.

IDSummaryPriorityStatusTagsEscalatedReported
SUP-4821Login redirect loop on SSOHighIn progressauthssoregressionJan 15, 2024
SUP-4819Export CSV missing header rowMediumOpenexportJan 22, 2024
SUP-4815Slow dashboard load for large workspacesMediumIn progressperformancedashboardsFeb 3, 2024
SUP-4808Typo in billing email subject lineLowResolvedbillingFeb 9, 2024
SUP-4802API rate limit hit during bulk importHighOpenapirate-limitFeb 14, 2024
SUP-4791Dark mode contrast on settings pageLowResolveduiaccessibilityFeb 20, 2024
Table: 6 tickets, columns typed as Badge/Status/Tag List/Boolean/Date/Link

Table settings

Columns

Add columns from the Add column… list, and drag their handle to reorder them. A table can hold up to 12 columns.

Setting
Description
Column name
Enter the heading to show for the column.
Renderer
Select how the column's values are drawn. The available renderers depend on the column's data type, listed below.
Remove
Click to remove the column from the table.
Drag handle
Drag to reorder the columns.

Available renderers by column type

Column type
Renderers available
Default renderer
Temporal
Date, Text
Date
Quantitative
Number, Delta, Progress, Text, Badge
Number
Ordinal
Text, Badge, Status, Tag List, Boolean, Link
Text
Nominal
Text, Badge, Status, Tag List, Boolean, Link
Text

Renderer options

Selecting a renderer reveals its own settings.

Number

Setting
Description
Decimals
Enter the number of decimal places, from 0 to 10.
Prefix
Enter text to place before the value, such as $.
Suffix
Enter text to place after the value, such as %.
Value colors
Map a range of values to a text color. Add an entry per band.

Text

Setting
Description
Value colors
Map a specific cell value to a specific text color. Add an entry per value.

Badge

Setting
Description
Default color
Choose the badge color to use for values with no explicit mapping.
Value colors
Map a specific cell value to a specific badge color.

Progress

Setting
Description
Max
Enter the value representing a full bar.

Link

Setting
Description
Label field
Select the column supplying the link text. Select URL only to display the raw URL.

Tag list

Setting
Description
Separator
Enter the character to split the cell value on to produce individual tags.
Tag color
Choose the color to apply to every tag in the column.

Boolean

Setting
Description
True label
Enter the text to display when the value is true.
True color
Choose the color to use when the value is true.
False label
Enter the text to display when the value is false.
False color
Choose the color to use when the value is false.

Date, Status, and Delta have no additional options. Date formats the value as a date, Status draws it as a health state indicator, and Delta shows the value as a change with direction.

Rich table

Setting
Description
Cell Padding (px)
Enter the space inside each cell, from 0 to 20.
Font Size (px)
Enter the font size for table text, from 8 to 24.
Hide Column Headers
Enable to remove the header row.
Transpose Table
Enable to swap the rows and columns, showing the headings as the left-hand column.
Row Link Field
Enter the name of the column containing a URL, to hyperlink the entire row.

Row highlight

Highlight rows based on a field's value. Pick a field, then choose how it's evaluated.

Setting
Description
Field
Select the column to evaluate.
Mode
For quantitative or temporal fields, select Thresholds to color rows by value bands, entered as a To value and a color, in ascending order. For nominal or ordinal fields, select Colors to map specific values to specific colors.
Today
Enable to compare a temporal field against today's date live, rather than a fixed value. Available for temporal fields.

Was this article helpful?


Have more questions or facing an issue?