Display data in a table

Classic dashboards have their own panels and methods of configuring them. For details about panels in classic dashboards, see Classic dashboard panels.

A table panel organizes and display the data returned by a query as a sortable table. Tables can interpret time series data as columns or rows, or can render each raw data point from a series in its own row. You can also add columns for each label in a series, and for common calculations of each series' data.

For details about the configuration options common to all panels, see Panels.

Add a table to a dashboard

⚠️

Queries that return an extremely large number of data points or invalid results can result in panel errors. For example, a query might return an error for exceeding server resource limits.

Observability Platform reports these errors with an icon that appears in the corner of the Preview pane of the Add panel or Edit panel interfaces, or on the panel when viewing it on the dashboard. Hold the pointer over the icon to view the error message.

To add a table panel to a standard dashboard:

Add a panel to a dashboard.
In the Add Panel interface, click the Type dropdown and select Table.
Add a query to the panel.
Click the Add button to add the panel to the dashboard and close the Add Panel interface.
Optional: On the dashboard, click Save to save the new panel to the dashboard.

Use a table's tooltip

Observablity Platform truncates the display of table values that exceed a column's width. To view the complete value, hold the pointer over the truncated value in the table.

Configure a table

You can configure a table by modifying its Settings.

Any changes you make in the panel's Settings tab are immediately reflected in the Preview pane, but take effect only when you click Apply in the Edit panel interface and then Save the dashboard.

⚠️

Observability Platform doesn't fully support directly editing a panel's JSON representation and recommends configuring panels in the user interface. Use the JSON representation only for managing your configuration as code with tools such as Chronoctl and Terraform.

To modify a table's settings using its Settings tab:

Edit the table panel.
In the Edit panel interface, click the Settings tab.

To discard and revert all of the panel's settings to their defaults, click Reset to defaults.

Modify a table's data format

The Data Format section in a table's Settings tab defines how the table interprets the panel's query results for tabular display.

To define the table's data format, select a Time series format.

Series to Rows displays each series as a row in the table. You must also select which Calculations to apply to the series and display in the table. If the series contains labels, you can also toggle Label-based columns, which adds a column for each series' label when enabled.
Series to Columns displays each series as a column in the table. Each row in the table represents one data point in the series with the timestamp indicated in the Time column.
Raw displays the timestamp and value for each data point of a selected series.

Modify a table's sorting

The Sorting section in a table's Settings tab controls the table's sorting order.

Sort by: Determines the column used to sort the table.
Sort order: Determines whether display the table's contents by its Default original data order, or to sort it in Ascending or Descending order. Observability Platform disables this field until you select a Sort by column.

To add multiple sorting criteria:

Set a Sort by column.
Click + (Add sort) to add a sorting criteria.

To remove a sorting criteria, click Delete on the row of the criteria you want to remove.

Modify a table's units

The Display section in a table's Settings tab controls how Observability Platform interprets the units of data in the table.

Abbreviate: Toggles whether to abbreviate units on the Y axis. For example, if enabled, Observability Platform renders a value of 100000000 as 100M. You can toggle this setting only if you set the Unit to Decimal or Bytes; Time units Time units are always abbreviated and Percent values don't require it. Defaults to true.
Unit: Defines the unit used to render the Y axis. This has the most significant effect when you enable Abbreviate. Defaults to Decimal.
- Decimal: Base 10 values. Observability Platform renders a value of 1000000 as 1M.
- Bytes: As decimal multiple-byte units. Observability Platform renders a value of 1000000 as 1MB.
- Time: Determines the unit of time that Observability Platform uses to interpret a numeric value. The unit you select isn't necessarily the unit Observability Platform displays.
  
  For example, if you select Nanoseconds, Observability Platform interprets a numeric value of 120 as 120 nanoseconds and renders it as 120ns. If you select Days, Observability Platform interprets the same value as 120 days and renders it as 4 months.
  
  Supported units are Nanoseconds, Microseconds, Milliseconds, Seconds, Minutes, Hours, Days, Weeks, Months, and Years.
- Percent: Interprets the value as a percentile, representing 0% to 100% on a range of either 0.0 to 1.0 (Percent (0.0-1.0)) or 0 and 100 (Percent (0-100)).
  
  For example, Observability Platform renders a value of 1.0 in Percent (0.0-1.0) as 100%, and in Percent (0-100) as 1%.
Decimals: Defines how many decimal places Observability Platform renders for
values. Default renders decimal places only if necessary and rounds to the nearest value. Numeric values from 0 to 4 render the corresponding number of decimal places.

Configure a table's columns

The Table columns tab in a table's Edit panel interface controls whether to display certain columns in the table and lets you edit their headings. The tab lists each table column in a separate row.

Visibility: Toggles whether to display the column.
Name: Displays the column's original name.
Display Name: Defines the name used in the column's header.
Order Use the arrows to reorder the table.

Heat map Gauge