Important: This documentation is about an older version. It's relevant only to the release noted, many of the features and functions have been updated or replaced. Please view the current version.

Documentation Grafana documentation Panels and visualizations Visualizations Table

Table

Tables are a highly flexible visualization designed to display data in columns and rows. The table visualization can take multiple datasets and provide the option to switch between them. With this versatility, it’s the preferred visualization for viewing multiple data types, aiding in your data analysis needs.

You can use a table visualization to show datasets such as:

• Common database queries like logs, traces, metrics
• Financial reports
• Customer lists
• Product catalogs

Any information you might want to put in a spreadsheet can often be best visualized in a table.

Tables also provide different styles to visualize data inside the table cells, such as colored text and cell backgrounds, gauges, sparklines, data links, JSON code, and images.

Configure a table visualization

The following video provides a visual walkthrough of the options you can set in a table visualization. If you want to see a configuration in action, check out the video:

Give it a try using Grafana Play

With Grafana Play, you can explore and see how it works, learning from practical examples to accelerate your development. This feature can be seen on Table Visualizations in Grafana.

Try it

Supported data formats

The table visualization supports any data that has a column-row structure.

Example

This example shows a basic dataset in which there’s data for every table cell:

csv Copy

Column1, Column2, Column3
value1 , value2 , value3
value4 , value5 , value6
value7 , value8 , value9

If a cell is missing or the table column-row structure is not complete, as in the following example, the table visualization won’t display any of the data:

csv Copy

Column1, Column2, Column3
value1 , value2 , value3
gap1   , gap2
value4 , value5 , value6

If you need to hide columns, you can do so using data transformations, field overrides, or by building a query that returns only the needed columns.

Column filtering

You can temporarily change how column data is displayed using column filtering. For example, you can show or hide specific values.

Turn on column filtering

To turn on column filtering, follow these steps:

1. In Grafana, navigate to the dashboard with the table with the columns that you want to filter.
2. Hover over any part of the panel to which you want to add the link to display the actions menu on the top right corner.
3. Click the menu and select Edit.
4. In the panel editor pane, expand the Table options section.
5. Toggle on the Column filter switch.

A filter icon (funnel) appears next to each column title.

Filter column values

To filter column values, follow these steps:

1. Click the filter icon (funnel) next to a column title.

   Grafana displays the filter options for that column.

2. Click the checkbox next to the values that you want to display or click Select all.

3. Enter text in the search field at the top to show those values in the display so that you can select them rather than scroll to find them.

4. Choose from several operators to display column values:

   • Contains - Matches a regex pattern (operator by default).
   • Expression - Evaluates a boolean expression. The character $ represents the column value in the expression (for example, “$ >= 10 && $ <= 12”).
   • The typical comparison operators: =, !=, <, <=, >, >=.

5. Click the checkbox above the Ok and Cancel buttons to add or remove all displayed values to and from the filter.

Clear column filters

Columns with filters applied have a blue filter displayed next to the title.

To remove the filter, click the blue filter icon and then click Clear filter.

Sort columns

Click a column title to change the sort order from default to descending to ascending. Each time you click, the sort order changes to the next option in the cycle. You can sort multiple columns by holding the Shift key and clicking the column name.

Dataset selector

If the data queried contains multiple datasets, a table displays a drop-down list at the bottom, so you can select the dataset you want to visualize. This option is only available when you’re editing the panel.

Configuration options

Panel options

Table options

Table footer options

Toggle the Show table footer switch on and off to control the display of the footer. When the toggle is switched on, you can use the table footer to show calculations on fields.

After you activate the table footer, make selections for the following options:

• Calculation - The calculation that you want to apply.
• Count rows - This option is displayed if you select the Count calculation. If you want to show the number of rows in the dataset instead of the number of values in the selected fields, toggle on the Count rows switch.
• Fields - The fields to which you want to apply the calculation. Grafana applies the calculation to all numeric fields if you don’t select a field.

Cell options

Cell options allow you to control how data is displayed in a table. The options are differ based on the cell type that you select and are outlined within the descriptions of each cell type. The following table provides short descriptions for each cell type and links to a longer description and the cell type options.

Cell type

By default, Grafana automatically chooses display settings. You can override these settings by choosing one of the following cell types to control the default display for all fields. Additional configuration is available for some cell types.

If you want to apply a cell type to only some fields instead of all fields, you can do so using the Cell options > Cell type field override.

Auto

This is a basic text and number cell.

It has the following cell options:

Sparkline

This cell type shows values rendered as a sparkline. To show sparklines on data with multiple time series, use the Time series to table transformation to process it into a format the table can show.

The sparkline cell type options are described in the following table. For more detailed information about all of the sparkline styling options (except Hide value), refer to the time series graph styles documentation.

Colored text

If thresholds, value mappings, or color schemes are set, the cell text is displayed in the appropriate color.

The colored text cell type has the following options:

Colored background

If thresholds, value mappings, or color schemes are set, the cell background is displayed in the appropriate color.

You can also set background cell color by row:

The colored background cell type has the following options:

Gauge

With this cell type, cells can be displayed as a graphical gauge, with several different presentation types controlled by the gauge display mode and the value display.

Gauge display mode

You can set three gauge display modes.

Option	Description
Basic	Shows a simple gauge with the threshold levels defining the color of gauge.
Gradient	The threshold levels define a gradient.
Retro LCD	The gauge is split up in small cells that are lit or unlit.

Value display

Labels displayed alongside of the gauges can be set to be colored by value, match the theme text color, or be hidden.

Option	Description
Value color	Labels are colored by value.
Text color	Labels match the theme text color.
Hidden	Labels are hidden.

JSON View

This cell type shows values formatted as code. If a value is an object the JSON view allowing browsing the JSON object will appear on hover.

For the JSON view cell type, you can set enable Cell value inspect. This enables value inspection from table cells. When the switch is toggled on, clicking the inspect icon in a cell opens the Inspect value drawer which contains two tabs: Plain text and Code editor.

Grafana attempts to automatically detect the type of data in the cell and opens the drawer with the associated tab showing. However, you can switch back and forth between tabs

Image

If you have a field value that is an image URL or a base64 encoded image, this cell type displays it as an image.

It has the following options:

Standard options

Data links

Value mappings

Thresholds

Field overrides