Table visualizations
You can use table visualizations to present data in a structured format with customizable elements such as custom and conditional formatting, hyperlinks, and images. This page explains how to control data presentation in table visualizations.
What's the difference between a table visualization and the results table?
A table visualization can be manipulated independently of the original results table that appears under the dataset.
By default, table visualizations appear with all columns hidden. To show or hide columns, click the 
eye icon next to the column name.
Reorder columns
With the table visualization widget selected, use the visualization editor to reorder table columns.
Customize column settings
Click a column name to open the column settings, then adjust any of the following options:
Setting | Description |
|---|---|
Column display name | Overrides the default column name shown in the table. |
Use for search | Makes the column searchable in table filters. |
Description | Adds hover text that explains the column's meaning or business context. |
Display as | Changes how the data is rendered, such as showing a number as currency or a timestamp as a date. |
Default column width | Sets the initial width (in pixels) for the column when the table loads. |
Allow HTML content | Enables HTML rendering inside cells, which is useful for badges, links, or inline images. To learn how to encode an image as a url, see Add images to text widgets. |
Font conditions | Applies conditional font color formatting based on value thresholds. |
Customize grid settings
Use the Grids tab to configure the following:
- Resizable columns: Enable dashboard viewers to resize columns.
- Items per page: Set the number of rows that appear on each page of the table.
- Freeze first N columns: Specify the number of columns to keep in place while allowing horizontal scrolling for the rest of the table.
Customize common data types
Use the Display as drop-down menu to control the data type of the displayed value. Depending on the data type, various customization options are available. For example, you can:
- Display floats out to three decimal places
- Show only the month and year of a date column
- Zero-pad integers
- Prepend or append text to your number fields
- Display values as Booleans
Text
The Allow HTML content field has the following behavior:
- Enabled: HTML content is run through an HTML sanitizer and the column is rendered as HTML.
- Disabled: The content is displayed without rendering the HTML.
Numeric and date-time
For reference information on formatting numeric and date and time data types, see:
Boolean values
To display cells as Boolean values, select Boolean from the Display as drop-down menu. You can customize the values that appear as false and true. You can also use the visualization editor to apply conditional formatting.
Customize special data types
Dahsboard table visualizations also support the following special data types: image, JSON, and link. Use the Display as drop-down menu to control the data type of the displayed value.
Link
To make HTML links from your dashboard clickable, select Link. If the value translates directly to a link, a clickable link appears in the table.
You can also set values for: URL template, Text template, Title template. These template fields control how an HTML link is rendered. The fields accept mustache-style parameters (double curly braces) for the column names in the table. The mustache parameters support the pipe filter urlEscape, which URL-escapes the value.
Image
If a field in your database contains links to images, select Image to display the images inline with your table results. To learn how to encode an image as a url, see Add images to text widgets.
JSON
If your data returns JSON formatted text, select JSON. This lets you collapse and expand elements in a clean format.