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.

Create a Table

By default, when you finish running your query, the result set will be displayed with all columns included, and their display name defaults to the name you gave them in the query.

If you want to display only some columns and change their display name, you can drag the fields in Table fields area and modify their labels.

The table can be sorted along a column that was already dragged in. You can either specify the column and sort direction at Sort section in the Settings tab, or directly click on the column name.

Styling options

Display

• Pagination Size: Number of rows displayed per page of table
• Row Number: Display the row number in front of table rows

Aggregation

• Total Row: Display a row with columns' totals
• Average Row: Display a row with columns' averages

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.