Skip to main content

Table Chart

A table chart displays query results as a table, supporting paging, column sorting, column totals and rich value formatting options, including support for custom HTML within a cell for complete freedom of formatting the data or displaying images.

Table chart Table chart

Data Requirements​

The table chart is always available. There are no requirements on the result data columns, except that values of some database-specific column types, such as BINARY, RECORD and ARRAY are not displayed - these need to be converted to another data type (e.g. textual or numeric) in a report's SQL query.

Interactive Features​

Sorting​

The table can be sorted by one or more columns by clicking on the column header, or clicking while holding Cmd/Ctrl to add additional columns to the sorting. To choose the sort order (ascending/descending/original), click multiple times to cycle through the options. In case the table is paged, the sorting is applied correctly across all rows and the current page displays the subset of rows according the the sorting.

image-500 image-500

Paging​

By default all table charts display 100 rows of data. If there are more rows, paging links Next and Previous are shown when hovering over the chart header. On desktop computers, the option Show all xxx rows can be selected to have the table display all the data on a single page, with regular scrolling available for navigation.

image-500 image-500

Configuration​

The following visual configuration options are available:

Table Formatting Table Formatting

  • S, M, L, XL: Preset sizes for the table content.

  • Column Headers: Whether column headers should be shown.

  • Row Numbers: Whether row numbers should be shown.

  • Human Column Headers: Whether column headers, which originate from the query result column names, should use human-friendly capitalization.

  • Column Totals: Whether to show column totals for numeric columns. The totals are always visible at the bottom of the chart and are always computed for the full data set, even if it is distributed over multiple pages.

    Hiding Some Column Totals

    If your result data contains one or more numerical columns for which a total is semantically not meaningful (e.g. database IDs), configure the column with No Totals. See Column Formatting.

  • Auto Column Width: Whether column width should be automatically adjusted to fit the content as best as possible.

Column Formatting​

To configure the formatting of individual table columns, select the Columns tab in the report editor's table chart configuration. For each column, select a formatting style that is suitable for the values (the default selection is made by Cluvio based on the column data type).

image-300 image-300

The additional formatting options available for a column depend on the selected format style and the table format configuration. For example, if Column Totals are enabled for the table, a No Totals option becomes available for numerical columns.

image-300 image-300

Drill-Down​

The drill-down configuration can be used to make table cells interactive, such that clicking on a cell applies a filter value (typically the value shown in the cell). For example, in the below configuration, a drill-down action was added to the Event Name column, such that selecting an event name will apply that name to the events filter (used by other reports on the same dashboard).

Drilldown Drilldown

Conditional Formatting​

Conditional formatting allows configuring a set of rules for columns that apply text and background formatting based on a cell's value.

Conditional Formatting Conditional Formatting

Embedded HTML

Even though any custom formatting can also be done via embedded HTML, conditional formatting makes it easier to define the formatting rules and has the benefit of keeping the raw result value free of markup, e.g. for a clean export to CSV/Excel and to retain correct sorting behavior for numerical data and prevent possible HTML injection when using HTML formatting with unsanitized result data originating from user input.