Display data in a table

A table panel organizes and displays the data returned by a query as table with sortable columns. 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.

To create a table chart or learn more about the configuration options common to all panels, see Panels.

Table chart queries

Table charts use one or more queries to retrieve data to visualize. Table charts use the following query Options to refine the displayed information, depending on your Datasource:

Query example

The following example creates a table with multiple label values:

sum by (instance, environment) (METRIC_NAME)

Replace METRIC_NAME with the name of any metric with labels.

Use a table’s tooltip

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

Export a table as CSV

You can export a table’s values as a CSV file.

1. In the panel, click the icon.
2. Select Export CSV.

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.

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:

1. Set a Sort by column.
2. 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.

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

  • 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.
• 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 the toggle. Defaults to true.

Configure a table’s thresholds

The Thresholds section in a table chart’s Settings tab defines values where Observability Platform renders each threshold range. You can set a single threshold to differentiate, or multiple thresholds to indicate severity level. For example, you might want a warning value in orange, and a critical value in red.

To create a new threshold:

1. Edit a table panel.
2. Click the Settings tab.
3. In the Thresholds section, click the plus icon.
4. Enter a value in the When value is >= text box.
5. Use the color box to select a color for the threshold.
6. Optional: Click (>) to expand a row and update the Message field.
7. Click the plus icon to add more threshold levels.
8. When finished, click Apply.

After applying the changes, the table updates with the selected color highlighting the violated threshold.

To delete a threshold value, click the caret (>) to expand the threshold definition, and then click Delete threshold.

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.