Grid

Overview

The grid widget displays query or dataset results in a table format on the dashboard. Use it to view raw data as-is or to aggregate and summarize data into tables using pivot tables. It supports various field types including numbers, dates, and IP addresses.

For general information about query widgets, see Query widget.

Grid settings

The grid widget does not have a separate chart settings modal. Configure rows, columns, and filters in the pivot table editor, and the results are displayed as a grid.

Pivot table editor

For instructions on using the pivot table editor, see Pivots.

Widget basic information

For basic information settings of the grid widget, see the left panel items in Query widget.

View cell details

When a cell contains long text or a large JSON/array value, the grid shows a preview and lets you open the full content in a modal using the more (⋯) button. The same behavior applies wherever the same grid component is used, including query results and parser results, not just the dashboard grid widget.

Cell preview rules

• Text: Only the first 200 characters appear in the cell. If the value also exceeds the column width, a more (⋯) button appears.
• Array or object: If a value has 10 or more items, only the first 3 are shown as a preview, along with the more (⋯) button and the total item count.

Cell detail modal

Use any of the following to open the full cell value in a 600x600 modal:

• Click the more (⋯) button on the cell.
• Select the cell and press Shift+V.
• Right-click the cell and choose View more.

JSON strings stored as text are also rendered as a JSON tree viewer in the modal. The tree expands up to 50 levels of nesting, and when expanded, unnecessary brackets are hidden so the structure is easier to scan.