Skip to main content

Features

The Business Table panel has the following features.

SectionDescription
Row groupingDemonstrates row grouping
Multi tables as tabsDemonstrates multi table as tabs
Auto-width columnsDemonstrates auto-width columns
Colored Background using ThresholdsDemonstrates coloring thresholds
Table footerExplains how the table footer works
Filtering using client and query dashboard variablesDemonstrates client and dashboard variable filters
SortingDemonstrates column sorting
PaginationExplains pagination
Pin ColumnsDemonstrates column pinning
Download buttonDemonstrates the Download button
Data linksDemonstrates data links

Row grouping

This feature allows you to combine unique field values into groups and collapse/expanse using little arrows.

The Business Table panel row grouping.
The Business Table panel row grouping.

Multi tables as tabs

The Business Table panel allows you to have a multi-tabs view and configure the fields of each view separately.

To add a new tab, use the New Table parameter. To add a column to an existing tab, use the New Column parameter.

The Business Table panel allows you have a multi tabs view.
The Business Table panel allows you have a multi tabs view.

Auto-width columns

The column width can be determined automatically within a specified range or explicitly hardcoded by a user in pixels.

Auto-width column property.
Auto-width column property.

Colored Background using Thresholds

The Business Table panel supports the Grafana Thresholds feature.

The Business Table panel supports the Grafana Thresholds feature.
The Business Table panel supports the Grafana Thresholds feature.

Every column of the Business Table panel has the Show in Footer property. If at least one column has it set up, then the Footer will be shown.

You can select the aggregation function separately for each column to be applied toward the value displayed in the Footer.

The Business Table panel supports the Footer feature.
The Business Table panel supports the Footer feature.

Filtering

The Business Table panel starts strong with the filtering feature offering two main options:

  • Client,
  • Query.

Client

Every column of the Business Table panel offers the Filter feature. If set to Yes, the funnel icon will appear next to the column header.

With the Filter Mode->Client, when a user clicks on the funnel icon, depends on the value type they see the two types for further filtering.

  • Search. It provides a form to type free text or enter a number value to use in the filtering.
  • Options. It provides a multi-select list of all existing values in the column.
The Client filtering feature of the Business Table panel.
The Client filtering feature of the Business Table panel.

Query

This method of filtering allows panel interconnectivity or use in the data links. With the Filter Mode->Query, the displayed data is filtered according to the selected dashboard variables.

The Query filtering feature of the Business Table panel.
The Query filtering feature of the Business Table panel.

Sorting

Every column of the Business Table panel has the Sort property. If set to Yes, the ascending sorting icon appears next to the column header. After the user clicks on the icon, the order changes to descending.

The Business Table panel supports the Sorting feature.
The Business Table panel supports the Sorting feature.

Pagination

You have a choice of two pagination modes: Client and Query.

The pagination feature modes.
The pagination feature modes.

Client

With the Client mode, all records are retrieved by the Business Table panel simultaneously and then divided into the pages by your browser. By default, ten rows per page are displayed. A user can change it to 20, 50, 100 or 1000.

The Client mode is the easiest and fastest to set up. However, users might experience performance issues since all data must be retrieved before being separated into pages.

The Client pagination mode.
The Client pagination mode.

Query

With the Query mode, only records needed for the current display are retrieved. That approach guarantees better performance for the end-users.

The determination of what records to retrieve (what records need to be displayed) is done by using the following variables:

  • pageIndex. Page order number. Specify as a dashboard variable name.
  • offset. How many rows to skip starting from the first. Specify as a dashboard variable name.
  • pageSize. The number of rows per page. Specify as a dashboard variable name.
  • Total Count Field. Specify as a dataframe:column name. Preffered to set to display total number of pages.

The necessity of the first three metrics (pageIndex, offset, pageSize) is contingent on the data source from which the data is sourced. Understanding this dependency will prepare you for efficient data retrieval.

In the example below, we use the Timescale data source, consequently SQL, to retrieve the data. pageIndex and offset are enough metrics in that case.

All dashboard variables that you ever might need to configure the Query pagination mode.
All dashboard variables that you ever might need to configure the Query pagination mode.
The Query pagination mode.
The Query pagination mode.

Pin Columns

It is a helpful feature for the wide tables. You can pin any column to always stay visible on the left or right.

Column pin parameter.
Column pin parameter.

Below, the column Country is pinned to the left.

The column Country is pinned to the left.
The column Country is pinned to the left.

Download button

You can add a download button right on the Business Table visualization for an intuitive user experience.

The download button.
The download button.

The Business Table visualization supports the Data links feature. In the example below, when a user clicks on a row, two links are suggested in the popup window.

You can use the Grafana Overrides feature to configure column links (not for the whole row).

The Business Table panel supports the Data links feature.
The Business Table panel supports the Data links feature.