Skip to main content

Table

Table is the default visualization to display your result set when your query finished processing.

When to use Table?​

Table works well when you want to have a feel of your raw data, for example, if you want to quickly compare several variables.

How to create a Table​

  1. Open Report Builder or Dataset Exploration.
  2. Select the Table Visualization option
  3. Drag and drop the fields you want to visualize.
  4. Click Get Result button

You can also:

  • Drag and drop columns/fields to reorder them.
  • Customize the display name (label) of a field.
  • Sort table columns.
  • Apply filters to the table.

Show / Hide Columns​

You can hide a column from a table in two ways:

  1. Click on any fields in the Visualization Settings and select Hide field.
  2. Click to open the Context Menu (arrow icon) of any columns in the table and choose Hide in view.

To unhide a column, click on that field in the Visualization Settings and select Show field.

Note

This is an aesthetics feature, not a security feature. Hiding a column will remove it from the user’s report view and export, but the data is still accessible and not restricted in any way.

Styling Options​

Display​

  • Pagination Size: Define number of rows displayed per page in the table.
  • Row Number: Display the row number at the beginning of each table row.
  • Row Height: Clip (single-line) or wrap (multiple-line) long-content cell. We recommend Single-line option for better performance
  • Column Freeze: Specify the number of columns to freeze from the left, including hidden columns, while excluding the Row Number column.

Conditional Formatting​

Conditional Formatting helps you color table cells based on their values just like in Excel. There are two formatting modes:

Single Color Mode​

Single Color Mode highlights only cells that satisfy a certain condition with the color you chose. This is useful when you want to single out some special values.

Color Scale Mode​

With Color Scale Mode, you can color cells in a color gradient. The color will depend on the cell's value in your specified data range. Min and max points are required, and the mid point is optional.

Aggregation​

  • Sum Row: Display a row with columns' sums
  • Average Row: Display a row with columns' averages

Others​

Let us know what you think about this document :)