This is documentation for the next version of Grafana documentation. For the latest stable release, go to the latest version.

Grafana Cloud Enterprise Open source

Table

Note

The updated table panel is currently in public preview and is being gradually rolled out to Cloud instances. Grafana Labs offers limited support, and breaking changes might occur prior to the feature being made generally available.

Some screenshots in this documentation might not reflect the public preview experience.

For information about the generally available experience, refer to the latest OSS documentation.

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.

Basic table visualization

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.

Note

Annotations and alerts are not currently supported for tables.

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
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.

Supported data formats

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

Note

If you’re using a cell type such as sparkline or JSON, the data requirements may differ in a way that’s specific to that type. For more info refer to Cell type.

Example

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

csv
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
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 header and cell menus

Column headers and cells both have menus where you can access various table options.

Column header menus include filtering options, and column management options. Cell menus include filtering and cell value inspection options.

Both column and cell menus can include the Ask Assistant option, which lets you provide that data as a context pill to Grafana Assistant. The pill carries a cell’s raw and formatted value, which field it belongs to, details of the query behind it, and which panel, dashboard, and time range it came from. For columns, it uses all the values in the column even if they’ve been filtered out. This option is only supported if you have Grafana Assistant enabled in your Grafana instance.

Column filtering

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

Filter column values

To filter column values, follow these steps:

  1. Click the menu icon on the right side of the column header and select Filter values.

    The dialog box with the filter options for the column opens.

    Filter column values
  2. Do one of the following, depending on the type of data in that column:

    • Values: Click the checkboxes next to the values you want to include or click Select all. To narrow the set of values, enter text in the search field and then choose an operator:

      • Contains - Matches a regular expression 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: =, !=, <, <=, >, >=.
    • Numeric ranges: Use the slider to set exact boundaries for the range. You can also enter values in one or both of the Minimum and Maximum fields to constrain the range.

    • Date ranges: Enter values in one or both of the Start and End fields.

      Select Include missing to retain empty results, null, NaN, and other special values.

  3. Click Apply to add the filters and close the dialog box.

Clear column filters

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

Filtered column

To remove the filter, click the filter icon and then click Clear filter. The icon no longer displays.

Cross-filter from a table cell

In tables, you can apply dashboard cross-filters directly from the visualization. Cross-filtering requires a Group by variable and a data source that supports dashboard filters, such as Prometheus or Loki.

To enable cross-filtering, follow these steps:

  1. Add a field override for the x-axis field, and select Standard options > Cross-filter.

  2. Toggle on the Cross-filter switch.

  3. Save the dashboard.

  4. Mouse over the cell to display the menu icon.

  5. Click the series that has the value you want to filter to display the filter control:

    Table with filter icon displayed on a cell
  6. Click the filter for or filter out icon.

    A filter to include or exclude that field is added and displayed at the top of the dashboard.

  7. In the filter field at the top of the dashboard, do the following as needed:

    • Change the operator to any of the following: =~, !~, <, <=, >, >=.
    • Delete the filter.

For more information about applying filters this way, refer to Cross-filtering.

Save or remove view changes

Whenever you show, hide, reorder, or filter a column, the table visualization displays an unsaved changes (eye) icon to indicate this:

Table header with unsaved changes icon displayed

Depending on your permissions, you can either save or remove these changes by clicking the drop-down list next to the icon and selecting the appropriate option:

  • Save changes: Dashboard editors only
  • Remove changes: Dashboard editors and viewers

Saving changes adds a transformation to the panel that reflects the change you made. This is helpful since you aren’t required to build a transformation from scratch.

The icon also reminds dashboard editors and viewers that changes have been applied and provides a way to reset the panel to its original version.

Example

In the following image, the Min column has been hidden, as shown in the column management sidebar:

Table with hidden column and unsaved changes icon displayed

After saving the changes, the table now has an Organize fields by name transformation that hides the column so it no longer has to be hidden by viewers of the table:

Table change saved as a Organize fields by name transformation

The Min column no longer appears in the table’s column management sidebar:

Table updated from saved changes

Column sorting

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 and then back to the default for the table. You can sort multiple columns by holding the Cmd or Ctrl key and clicking the column name.

When you sort a column, an arrow displays next to column title indicating the direction of the sorting:

Sort descending

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.

Table visualization with multiple datasets

Nested tables

A table can display sub-tables inside expandable rows. You can add these nested tables using the Group to nested tables transformation, which groups rows by one or more fields, and can summarize nested row data by applying calculations.

Table with all rows collapsed

Click the expand icon on a row to toggle the visibility of its nested table:

Table with two rows expanded showing nested sub-tables

To sort nested and top-level rows in nested tables, 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 Cmd or Ctrl key and clicking the column name.

Sort descending

To control the display of fields inside a nested table—for example, to apply thresholds, units, or a different cell type—use field overrides with the Target fields option set to Nested. For more information, refer to Apply overrides to nested table fields.

Configuration options

Panel options

In the Panel options section of the panel editor pane, set options like the panel title, description, and show/hide rules. To learn more, refer to Configure panel options.

OptionDescription
TitleText entered in this field appears at the top of your panel in the panel editor and in the dashboard. You can use variables you have defined or built-in variables.
DescriptionAdd a description to a panel to share with users any important information about it, such as its purpose. Text entered in this field appears in a tooltip in the upper-left corner of the panel. Conversely, toggle on the Use as subtitle switch to display the description just below the panel title instead. You can use variables you have defined or dashboard-scoped built-in variables (such as $__from, $__to, $__dashboard, $__org, and $__user). Query-scoped global variables (such as $__interval and $__interval_ms) are not available in this field.
Transparent backgroundToggle this switch on and off to control whether or not the panel has the same background color as the dashboard.
Panel linksAdd links to the panel to create shortcuts to other dashboards, panels, and external websites. Access panel links by clicking the icon next to the panel title.
Repeat optionsSet whether to repeat the panel for each value in the selected variable.
Show/hide rulesSet whether to show or hide panels based on various rules.

Table options

OptionDescription
Show table headerShow or hide column names imported from your data source.
Show row numbersDisplay row numbers on the left side of the table. For more information, refer to Show row numbers.
Frozen columnsFreeze columns starting from the left side of the table. Enter a value to set how many columns are frozen.
Cell heightSet the height of the cell. Choose from Small, Medium, or Large.
Zebra stripingAlternate the background color of every other row.
Show columns sidebarToggle on the switch to have the column management sidebar open by default. In the sidebar, you can hide, show, and reorder columns. Viewers can close the sidebar when interacting with the table, but it’s open by default the next time they load the visualization.
Max row heightDefine the maximum height for a row in the table. This can be useful when Wrap text is enabled for one or more columns.
Enable paginationToggle the switch to control how many table rows are visible at once. When switched on, the page size automatically adjusts to the height of the panel. This option doesn’t affect queries.
Page sizeDefine the number of rows per page when the Enable pagination switch is toggled on. When this field is empty, the page size automatically adjusts to the height of the panel.
Minimum column widthDefine the lower limit of the column width, in pixels. By default, the minimum width of the table column is 150 pixels. For small-screen devices, such as mobile phones or tablets, reduce the value to 50 to allow table-based panels to render correctly in dashboards.
Column widthDefine a column width, in pixels, rather than allowing the width to be set automatically. By default, Grafana sizes columns to fit cell content relative to the width of the table.
Column alignmentSet how Grafana should align cell contents. Choose from: Auto (default), Left, Center, or Right.
Wrap textEnables text wrapping for cell content.
Wrap header textEnables text wrapping for column headers.

Show row numbers

Enable Show row numbers to display row positions on the left side of the table. Numbers start at 1, reflect the displayed order after sorting and filtering, and continue across pages.

For nested tables, each nested table starts its own sequence at 1, and footer rows aren’t numbered. Expanding a parent row doesn’t change the parent numbers.

The row number isn’t a data field and can’t be resized or unpinned.

The table footer displays the results of calculations (and reducer functions) on fields. The footer is only displayed after you select an option in the Calculation drop-down list:

The footer calculation selector, open

There are several calculations you can choose from including minimum, maximum, first, last, and total. For the full list of options, refer to Calculations.

In the table footer:

  • You can apply multiple calculations at once.
  • The calculations and reducer functions apply to all fields in the table, by default. To control which fields have a calculation or function applied, add the table footer in an override instead.
  • If you enable a mathematical function for a non-numeric field, nothing for that function is displayed for that field.

In the following image, multiple calculations—Mean, Max, and Last—have been applied:

Table with footer displaying mean, max, and last

You can also see in the previous image that the mathematical functions, Mean and Max, haven’t been applied to the text field in the table. Only the Last function has been applied to that field.

Note

Calculations applied to cell types like Markdown + HTML might have unexpected results.

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.

Cell typeDescription
AutoA basic text and number cell.
Colored textIf thresholds, value mappings, or color schemes are set, then the cell text is displayed in the appropriate color.
Colored backgroundIf thresholds, value mappings, or color schemes are set, then the cell background is displayed in the appropriate color.
Data linksThe cell text reflects the titles of the configured data links.
GaugeValues are displayed as a horizontal bar gauge. You can set the Gauge display mode and the Value display options.
SparklineShows values rendered as a sparkline.
JSON ViewShows values formatted as code.
PillDisplays each item in a comma-separated string in a colored block.
Markdown + HTMLDisplays rich markdown or HTML content.
ImageDisplays an image when the value is a URL or a base64 encoded image.
ActionsThe cell displays a button that triggers a basic, unauthenticated API call when clicked.

Auto

This is a basic text and number cell.

It has the following cell options:

OptionDescription
Cell value inspect

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.

Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

Colored text

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

Table with colored text cell type

The colored text cell type has the following options:

OptionDescription
Cell value inspect

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.

Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

Colored background

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

Table with colored background cell type

You can also set background cell color by row:

Table with background cell color applied to row

The colored background cell type has the following options:

OptionDescription
Background display modeChoose between Basic and Gradient.
Apply to entire rowToggle the switch on to apply the background color that’s configured for the cell to the whole row. When more than one field has this option enabled (for example, when it’s set through the panel-level cell type or through overrides that target multiple fields), the row uses the color from the first (leftmost) matching column.
Cell value inspect

Enables value inspection from table cells. When the switch is toggled on, cells display a menu icon on hover. Click the menu and select Inspect value to open a 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.

Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to the Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

If you’ve configured data links, when the cell type is Auto, the cell text becomes clickable. If you change the cell type to Data links, the cell text reflects the titles of the configured data links. To control the application of data link text more granularly, use a Cell option > Cell type > Data links field override.

Gauge

With this cell type, cells can be displayed as a graphical gauge, with several different presentation types.

The gauge cell type has the following options:

OptionDescription
Gauge display modeControls the type of gauge used. For more information, refer to the Gauge display mode.
Value displayControls how the value is displayed. For more information, refer to the Value display.
Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

Note

The maximum and minimum values of the gauges are configured automatically from the smallest and largest values in your whole dataset. If you don’t want the max/min values to be pulled from the whole dataset, you can configure them for each column using field overrides.

Gauge display mode

You can set three gauge display modes.

OptionDescription
BasicShows a simple gauge with the threshold levels defining the color of gauge.
Table cell with basic gauge mode
GradientThe threshold levels define a gradient.
Table cell with gradient gauge mode
Retro LCDThe gauge is split up in small cells that are lit or unlit.
Table cell with retro LCD gauge mode
Value display

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

OptionDescription
Value colorLabels are colored by value.
Table with labels in value color
Text colorLabels match the theme text color.
Table with labels in theme color
HiddenLabels are hidden.
Table with labels hidden

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.

You can color sparklines using thresholds by setting the field’s color scheme to From thresholds (by value) in the standard color scheme options, using an override, and setting Gradient mode to Scheme. When thresholds are defined, the sparkline automatically reflects threshold levels along the line.

Table using sparkline cell type

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.

OptionDescription
Hide valueToggle the switch on or off to display or hide the cell value on the sparkline.
Show hover tooltipToggle the switch on or off to display or hide the cell value in a tooltip when you hover your cursor over the line.
StyleChoose whether to display your time-series data as Lines, Bars, or Points. You can use overrides to combine multiple styles in the same graph.
Line interpolationHow the graph interpolates the series line. Choose from:
  • Linear - Points are joined by straight lines.
  • Smooth - Points are joined by curved lines that smooths transitions between points.
  • Step before - The line is displayed as steps between points. Points are rendered at the end of the step.
  • Step after - The line is displayed as steps between points. Points are rendered at the beginning of the step.
Line widthThe thickness of the series lines or the outline for bars using the Line width slider.
Fill opacityThe series area fill color using the Fill opacity slider.
Gradient modeGradient mode controls the gradient fill, which is based on the series color. Gradient appearance is influenced by the Fill opacity setting. To change the color, use the standard color scheme field option. For more information, refer to Color scheme. Choose from:
  • None - No gradient fill. This is the default setting.
  • Opacity - An opacity gradient where the opacity of the fill increases as y-axis values increase.
  • Hue - A subtle gradient that’s based on the hue of the series color.
  • Scheme - The sparkline line color automatically reflects the configured threshold levels when the color scheme is set to From thresholds (by value) and thresholds are defined.
Line styleChoose from:
  • Solid
  • Dash - Select the length and gap for the line dashes. Default dash spacing is 10, 10.
  • Dots - Select the gap for the dot spacing. Default dot spacing is 0, 10.
Connect null valuesHow null values, which are gaps in the data, appear on the graph. Null values can be connected to form a continuous line or set to a threshold above which gaps in the data are no longer connected. Choose from:
  • Never - Time series data points with gaps in the data are never connected.
  • Always - Time series data points with gaps in the data are always connected.
  • Threshold - Specify a threshold above which gaps in the data are no longer connected. This can be useful when the connected gaps in the data are of a known size or within a known range, and gaps outside this range should no longer be connected.
Show pointsWhether to show data points to lines or bars. Choose from:
  • Auto - Grafana determines a point’s visibility based on the density of the data. If the density is low, then points appear.
  • Always - Show the points regardless of how dense the dataset is.
  • Never - Don’t show points.
Point sizeSet the size of the points, from 1 to 40 pixels in diameter.
Bar alignmentSet the position of the bar relative to a data point.
Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

JSON View

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

JSON view

It has the following cell options:

OptionDescription
Syntax highlightingEnables syntax highlighting for JSON values.
Cell value inspect

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.

Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.
Styling from fieldToggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax (for example, {"name":"John"}). For more information, refer to the Styling from field.

Pill

The Pill cell type displays each item in a comma-separated string in a colored block.

Table using the pill cell type

The colors applied to each piece of text are maintained throughout the table. For example, if the word “test” is first displayed in a red pill, it will always be displayed in a red pill.

The following data formats are supported for the pill cell type:

  • Comma-separated values (cows,chickens,goats)
  • JSON arrays of uniform ((["cows","chickens","goats"])) or mixed ([1,2,3,"foo",42,"bar"]) types

Toggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.

Markdown + HTML

The Markdown + HTML cell type displays rich Markdown or HTML content, rendered using the GitHub-Flavored Markdown spec. This is useful if you need to display customized, pre-formatted information alongside tabular data, such as formatted strings, lists of links, or other dynamic cases.

For this cell type, you can toggle the Dynamic height switch, which allows the cell to resize dynamically based on the cell content. If you use dynamic height, we strongly recommend that you also toggle on Pagination to avoid performance issues in larger tables, since enabling Dynamic height disables table virtualization.

By default, the HTML rendered is sanitized, and un-sanitized HTML can only be rendered in these cells if the disable_sanitize_html option is set to true for your Grafana instance.

Toggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.

Table using the pill cell type

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.

Table with image cell type

It has the following options:

OptionDescription
Alt textSet the alternative text of an image. The text will be available for screen readers and in cases when images can’t be loaded.
Title textSet the text that’s displayed when the image is hovered over with a cursor.
Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.

Actions

Actions add a button to a cell that triggers a basic, unauthenticated API call when clicked. Configure actions from Data links and actions or with field overrides.

OptionDescription
EndpointEnter the endpoint URL.
MethodChoose from GET, POST, and PUT.
Content-TypeSelect an option in the drop-down list. Choose from: JSON, Text, JavaScript, HTML, XML, and x-www-form-urlencoded.
Query parametersEnter as many Key, Value pairs as you need.
Header parametersEnter as many Key, Value pairs as you need.
PayloadEnter the body of the API call.
Tooltip from fieldToggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip. For more information, refer to Tooltip from field.

Tooltip from field

Toggle on the Tooltip from field switch to use the values from another field (or column) in a tooltip.

When you toggle the switch on, you can select from a drop-down list any of the fields in the table to be used as the source of the tooltip content. All table fields are included in the drop-down list, whether visible or hidden.

When a tooltip from a field has been added to a cell, a chip is displayed in the top-right or top-left corner of the cell:

Tooltip chip

Hover your mouse over the chip to display the tooltip.

When you toggle on the switch, the Tooltip placement option, which controls where the tooltip box opens upon hover, is also displayed. Select one of the following options: Auto, Top, Right, Bottom, and Left.

The content of the tooltip is determined by the values of the source field and can’t be directly edited. However, you can affect the display of the value using overrides like value mappings, as shown in the Example: Tooltip from field with value mappings section.

While you can turn on this option under Cell options and have it applied to all cells in the table, it’s typically used as an override on a sub-set of cells instead. This is demonstrated in the example in the following section.

Example: Tooltip from field using overrides

The following table has five visible fields (columns) as well as a hidden field called “Info”:

Table that includes a hidden column
  • The “Info” field is hidden using the Table > Hide in table override property.
  • The following overrides have been applied to the “Short text” field:
    • The values from the “Info” field are used as tooltip text for the “Short text” cells using the Cell options > Tooltip from field override property.
    • The Cell options > Tooltip placement override property is set to control the placement of the tooltip.
Override to use the Info field values as tooltips for the Short text column

Now, when you hover the cursor over the chip in the “Short text” column, the corresponding values from the “Info” column appear in the tooltip:

Info field value in the tooltip of the Short text cell upon hover
Example: Tooltip from field with value mappings

While the content of the tooltip is determined by the values of the source field and can’t be directly edited, you can use field overrides on the source field to manipulate the display of that value.

For example, if the “Info” column is being used as the source field for the tooltip values, you could set up a value mapping. In this case, the value “up” is mapped to the word “Good”:

Info field value up being mapped to the value Good in an override

Now, when you hover the cursor over the chip in the “Short text” cell, the mapped value appears in the tooltip:

Info field mapped to a new value in the tooltip of the Short text cell upon hover

You can use all field overrides to affect the display of the tooltip. For example, the Table > Column width or Cell options > Cell type overrides can change the cell width or visual display of the data.

Styling from field

Toggle on the Styling from field switch to apply the styling from another field (or column). The referenced field must contain CSS properties formatted in JSON object syntax. For example:

JSON
{"marginLeft":12, "text-decoration": "underline"}

While you can turn on this option under Cell options and have it applied to all cells in the table, it’s typically used as an override on a sub-set of cells instead. This is demonstrated in the following example.

The following table has six visible fields (columns) as well as a hidden field called “Style”:

Configuration of a table including the styling from field option
  • The “Style” field has JSON objects with CSS properties. (Note that they are formatted for use in CSV format in this example.)
  • The “Style” field is hidden using the Table > Hide in table override property.
  • The “Info” field is using the Cell options > Styling from field override property with the “Style” field as the source.

The following image shows the “Info” field with the styling from the “Style” field applied:

Info field with styling from Style field applied

Standard options

Standard options in the panel editor pane let you change how field data is displayed in your visualizations. When you set a standard option, the change is applied to all fields or series. For more granular control over the display of fields, refer to Configure overrides.

OptionDescription
UnitChoose which unit a field should use.
Min/MaxSet the minimum and maximum values used in percentage threshold calculations or leave these field empty for them to be calculated automatically.
Field min/maxEnable Field min/max to have Grafana calculate the min or max of each field individually, based on the minimum or maximum value of the field.
DecimalsSpecify the number of decimals Grafana includes in the rendered value.
Display nameSet the display title of all fields. You can use variables in the field title.
Color schemeSet single or multiple colors for your entire visualization.
No valueEnter what Grafana should display if the field value is empty or null. The default value is a hyphen (-).

To learn more, refer to Configure standard options.

Data links allow you to link to other panels, dashboards, and external resources and actions let you trigger basic, unauthenticated, API calls. In both cases, you can carry out these tasks while maintaining the context of the source panel.

For each data link, set the following options:

  • Title
  • URL
  • Open in new tab

Data links for this visualization don’t include the One click switch, however, if there’s only one data link configured, that data link has single-click functionality. If multiple data links are configured, then clicking the visualization opens a menu that displays all the data links.

For each action, define the following API call settings:

OptionDescription
TitleA human-readable label for the action that’s displayed in the UI.
Confirmation messageA descriptive prompt to confirm or cancel the action.
ConnectionSpecify how the action’s HTTP request is sent. Choose from: Direct from browser or routed through a configured data source.
MethodSelect from POST, PUT, or GET.
URLThe request URL.

To add a variable, click in the URL field and enter $ or press Ctrl+Space or Cmd+Space to see a list of available variables.

VariablesKey and Name pairs with a type selection. Click the + icon to add as many variables as you need. To add a variable to the request, prefix the key with $. You can set the values for the variables when performing an action.
Query parametersKey and Value pairs. Click the + icon to add as many key/value pairs as you need.
HeadersComprised of Key and Value pairs and a Content-Type.

Click the + icon to add as many key/value pairs as you need.

Content-TypeSelect from the following: application/json, text/plain, application/XML, and application/x-www-form-urlencoded.
BodyThe body of the request.

To learn more, refer to Configure data links and actions.

Value mappings

Value mapping is a technique you can use to change how data appears in a visualization.

For each value mapping, set the following options:

  • Condition - Choose what’s mapped to the display text and (optionally) color:
    • Value - Specific values
    • Range - Numerical ranges
    • Regex - Regular expressions
    • Special - Special values like Null, NaN (not a number), or boolean values like true and false
  • Display text
  • Color (Optional)
  • Icon (Canvas only)

To learn more, refer to Configure value mappings.

Thresholds

A threshold is a value or limit you set for a metric that’s reflected visually when it’s met or exceeded. Thresholds are one way you can conditionally style and color your visualizations based on query results.

For each threshold, set the following options:

OptionDescription
ValueSet the value for each threshold.
Thresholds modeChoose from Absolute and Percentage.

To learn more, refer to Configure thresholds.

Field overrides

Overrides allow you to customize visualization settings for specific fields or series. When you add an override rule, it targets a particular set of fields and lets you define multiple options for how that field is displayed.

Choose from the following override options:

OptionDescription
Fields with nameSelect a field from the list of all available fields.
Field with name matching regexSpecify fields to override with a regular expression.
Fields with typeSelect fields by type, such as string, numeric, or time.
Fields returned by querySelect all fields returned by a specific query, such as A, B, or C.
Fields with valuesSelect all fields returned by your defined reducer condition, such as Min, Max, Count, Total.

To learn more, refer to Configure field overrides.

Apply overrides to nested table fields

By default, field overrides apply only to columns in the parent table. To target columns inside a nested table, set the Target fields option on the override to Nested:

Field override configuration with the Target fields selector showing Series and Nested options

All standard override properties—including thresholds, value mappings, units, data links, and cell type—apply the same way to nested fields.

Nested table with a threshold override applied to a column inside an expanded sub-table