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
- Open Report Builder or Dataset Exploration.
- Select the Table Visualization option
- Drag and drop the fields you want to visualize.
- 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.
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 be frozen from the left, 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