Data Table (Chart Type)

Using Data Tables you can show and aggregate data in a table format. You can aggregate on multiple dimensions and look at different measures (e.g., summary of per unit values).

Data Preview

On the right side of the New Portlet screen there is a Data Preview section where you can preview all the changes made when you click the Apply and Refresh.

Data

The Data tab shows a configurable view of all columns returned by the underlying query. Any changes you make to column labels, order, or visibility are applied immediately and saved with the portlet configuration.

Source Data

The Data Source tab always shows the raw, read‑only result set returned by the query. It is not affected by any changes made in the Data tab or side configuration panel and does not support layout options such as column freezing, reordering, or hiding.

Chart Type

Data Table

Data

The Data Table (Chart Type) includes a configurable Data tab. The tab shows all columns returned by the underlying query, and users can easily tailor how the table looks without losing access to any data. From the side configuration panel, users can:

• Rename column labels to match business terminology.

• Reorder columns to highlight the most important information first.

• Show or hide columns to reduce noise while keeping all fields available when needed.

Mini Bar Chart

Mini bar charts let you quickly compare numeric values directly inside a Data Table column. When enabled for a measure column, each cell shows a small horizontal bar alongside the number, so you can see relative magnitude at a glance without leaving the tabular view.

Colors

• Positive and negative values use different bar colors by default.

  

• The user can change both positive and negative bar colors in the Show a mini bar chart menu.

  

How to Enable

1. In the Data Table chart configuration.

2. Click Data.

3. Select the measure column.

4. Click icon.

5. Click Show a mini chart bar.

6. Click Apply.

Cell Values & Chart Display

Cell Value	Description	Example
0	The cell always shows the numeric value. It may show either no bar or a minimal bar, but the cell is never empty.
Null NaN	No bar is displayed.
Positive and negative values	If the column contains both positive and negative values, a zero indicator (zero line) is displayed.
Positive or only negative values	If values are only positive or only negative, the zero indicator is hidden.

Sorting Filtering & Persistence

• Sorting and filtering continue to work on the numeric values only. The mini bars are purely visual.

• The On/Off state and chosen colors are saved with the widget and restored when the dashboard is opened again.

Limitations

• The bar length shows relative magnitude within the column.

• Pagination or filters, bar scaling is based on the currently loaded rows.

Formatting

Formatting tab allows you to define conditional formatting rules for your data. Use can this tab to highlight important values in your table based on custom conditions.

• Select Column – Choose the Data Table column where you want to apply conditional formatting. Only supported columns (such as numeric and text fields) are available in the list.
  Select Column dropdown supports type-ahead search. You can start typing the column name in the field picker to quickly filter the list and avoid scrolling.

• Condition – Define the rule that decides when cells are highlighted. Select an operator and specify the value the column is compared to. The following options are available:
  Condition dropdown supports type-ahead search. You can start typing the column name in the field picker to quickly filter the list and avoid scrolling.

  • equals

  • not equal

  • contains

  • does not contain

  • starts with

  • does not start with

  • ends with

  • does not end with

  • is null

  • is not null

• Apply color – Select the highlight color used for cells that meet the defined condition. The chosen color is applied as the cell background in the selected column.