Skip to main content
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 in Palo Alto Networks Cortex XCOR organizes and displays the data returned by one or more queries as a table with sortable columns. For a metrics query, each row is one series, with a column for each of the series’ labels and a column for its value. A table can combine the results of several queries into one row per series. 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 type: In the collapsible Options at the bottom of the Query tab, select the PromQL query type:
    • Instant: Query for the latest value in the time range.
    • Range: Query for values across the time range. When you select Range, also set Reduce values in time range to to choose how Cortex XCOR reduces each series to a single value:
      • Avg: The series’ mean value, excluding null values.
      • First: The series’ first value.
      • First *: The series’ first numeric value.
      • Last: The series’ last value.
      • Last *: The series’ last numeric value.
      • Min: The series’ minimum value.
      • Max: The series’ maximum value.
      • Total: The total of all values in the series.
  • Min step: The minimum step for the PromQL query. This option appears when Query type is Range.
  • Truncation strategy: Truncation strategy to apply to the query. This modifies the raw query. Cortex XCOR selects the best strategy for fit when possible, and displays Auto as the selected strategy. Available strategies are:
    • Auto
    • Off
    • Avg
    • Min
    • Max
    Changing your truncation strategy adds truncation information as additional bands or bars on your chart and details into the legend.

Query example

The following example creates a table with multiple label values:
Replace METRIC_NAME with the name of any metric with labels.

Combine multiple queries

When a table has more than one query, Cortex XCOR joins the results into a single table. Rows from different queries merge into one row when they have the same label set, and each query adds its own value column. For example, three queries that each aggregate by (container) produce one row per container, with one value column per query. A table combines its queries when all of the following are true:
  • The table’s Time series format is Default. The other formats don’t merge rows across queries. See Modify a table’s data format.
  • Every query returns the same labels, for example, by aggregating each one with sum by (container). Rows merge only when every label matches, so a query that returns an extra label produces separate rows for its series.
  • Each query has an Alias. The alias becomes the header of that query’s value column. Without aliases, the value columns are named Value, Value (2), Value (3), and so on.
Each value column holds the latest value for an Instant query, or the reduced value for a Range query, as set by the query’s Query type option. In the panel’s JSON representation, omit the transform field from the table’s spec, and set alias on each query. The transform field is deprecated. It selects one of the legacy formats, which don’t merge queries. For a complete example, see Table that combines multiple queries.

Use a table’s tooltip

Cortex XCOR 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. Cortex XCOR doesn’t fully support directly editing a panel’s JSON representation. To configure a panel, edit it and modify individual fields. 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.
  • Default displays the query results as returned, with one row per series, a column for each label, and a value column for each query. Rows from multiple queries merge when their labels match. Use this format for new tables. See Combine multiple queries.
  • 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.
Series To Rows, Series To Columns, and Raw are legacy formats. They reshape raw time series in the browser instead of displaying the query results directly, and they don’t merge rows across queries. In the panel’s JSON representation, these formats set the table’s transform field, and Default omits it. Changing the format resets the table’s sorting and the settings in its Table columns tab.

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 to display the table’s contents in its Default original data order, or to sort it in Ascending or Descending order. Cortex XCOR 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. In the expanded panel view, click a column header to sort by that column. Each click toggles between ascending and descending order.

Modify a table’s units

The Unit and formatting section in a table’s Settings tab controls how Cortex XCOR 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. Cortex XCOR renders a value of 1000000 as 1M.
    • Bytes: As decimal multiple-byte units. Cortex XCOR renders a value of 1000000 as 1MB.
    • Time: Determines the unit of time that Cortex XCOR uses to interpret a numeric value.
    • Percent: Interprets the value as a percentile, representing 0% to 100% in a range of either 0.0 to 1.0 (Percent (0.0-1.0)) or 0 and 100 (Percent (0-100)). For example, Cortex XCOR 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 Cortex XCOR 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, Cortex XCOR renders a value of 100000000 as 100M. You can toggle this setting only if you set the Unit to Decimal or Bytes; Time units are always abbreviated and Percent values don’t require the toggle. Defaults to true.
To discard your changes and restore the panel’s settings to their defaults, click Reset all settings to defaults.

Configure a table’s thresholds

The Thresholds section in a table chart’s Settings tab defines values where Cortex XCOR 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 the caret (>) 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.
Expand a column row to set its Type and column-specific formatting. Choose Number, String, or Time. Set Type to Number when a column stores numeric text so the table sorts and formats values numerically instead of sorting lexically by string.

Table examples

The following examples are JSON formatted dashboard code. Modify the variables in these examples for your tenant and applications.

Table that combines multiple queries

This table compares CPU usage with CPU requests for each container in a Kubernetes namespace. Each query aggregates by (container), so the table merges the three results into one row per container. Each query’s alias names its value column, and the columnOverrides entries rename the container label column and format the ratio as a percentage. The queries use a dashboard variable named namespace.
Table that combines multiple queries

Table with severity by color

This table lists items sorted by severity, and applies color to the Severity column based on the resulting value:
Table with colored severity

Table with additional columns

This table overrides the default columns and adds additional columns:
Additional columns

Table with custom columns and color coding based on result

This table adds custom columns and adds color to one of the columns based on the query result:
Custom columns and color coding