---
title: "Build widgets in Search"
slug: "build-widgets-in-search"
updated: 2026-10-27T16:22:14Z
published: 2026-10-27T04:48:21Z
canonical: "docs.hunters.ai/build-widgets-in-search"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hunters.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Build widgets in Search

Every dashboard widget is built on the Search page, in SQL mode: run a query, then select **Create Widget**. Widgets are not available in Builder mode or in notebooks.

![Create Widget](https://cdn.document360.io/5f63f0e0-3c70-4d00-b623-82493be0bde5/Images/Documentation/widget-bar-controls.png?sv=2026-02-06&spr=https&st=2026-10-27T20%3A04%3A08Z&se=2026-10-27T21%3A04%3A08Z&sr=c&sp=r&sig=OIX7Z0bNswHaGf6aijf0GTDD8N6HSgn8Fixwa64b%2Bf4%3D)

## Which columns you can pick

The pickers do not read the database schema. They classify columns from a sample of up to 100 result rows:

- Only columns your `SELECT` returns are offered. To make a column selectable, add it to the query.
- Time columns appear only under **Group By → Time**, and are never offered for aggregation.
- **Sum**, **Min**, **Max** and **Avg** offer only numeric columns. **Count unique** offers every column.
- **Ratio** exists only on the **Gauge** chart type.

              The preview is not the widget

              

The preview is computed in your browser from the sample rows. It is not the same computation as the finished widget, and it can group differently. Use it to check the layout; check the numbers on the created widget.

## Bar charts: sort and limit

A Bar chart grouped by a field gets **Sort bars by value** and **Number of bars**. They are available with no series split, or with a split measured by Sum, Count or Count unique.

| Sort | Bars kept by the limit |
| --- | --- |
| Descending or Off | The largest |
| Ascending | The **smallest** |

Bars past the limit are dropped, not grouped into "Other". On a split chart, the limit keeps whole categories.

Split bars stack only for Sum, Count and Count unique. Avg, Min and Max render side by side, because a stacked average is meaningless.

## Limits

|  |  |
| --- | --- |
| **Data points** | A chart with more than 1,500 points shows *Chart cannot be displayed*. Use **Number of bars** or a coarser grouping. |
| **Time resolution** | `minute`, `hour`, `day`, `month`, `year`. There is no `week`. |
| **Pivot columns** | The column axis is capped at 200 values (RAW Data and OCSF Data) or 100 (Analytics). A notice appears above the grid when the cap is hit. A time-bucketed pivot keeps the **earliest** buckets. |
| **Table rows** | A Table widget shows at most 1,000 rows. |

Tables can rename any column; Pivots can rename only their row-axis columns. Table and Pivot cells show up to 2 decimal places, or up to 4 for small values.

## Add to dashboard

Widgets in the **Widgets** area are not saved. Use **⋮ → Add to dashboard** to keep one.

![Add to dashboard](https://cdn.document360.io/5f63f0e0-3c70-4d00-b623-82493be0bde5/Images/Documentation/add-to-dashboard.png?sv=2026-02-06&spr=https&st=2026-10-27T20%3A04%3A08Z&se=2026-10-27T21%3A04%3A08Z&sr=c&sp=r&sig=OIX7Z0bNswHaGf6aijf0GTDD8N6HSgn8Fixwa64b%2Bf4%3D)

- **The list shows only dashboards you created.** To add a widget to someone else's dashboard, open that dashboard and select **Make a copy** first. Type a new name to create a dashboard.
- **Time column** is the column the dashboard's time range will filter. Choose **None** to make the widget ignore the time range.

              Don't filter time in the SQL as well

              

If your SQL filters on the time column you nominate, the two filters stack and the dashboard can only narrow the range, never widen it. Leave the range open in SQL and let the dashboard control it.

## Edit Query edits the dashboard's copy

A dashboard widget's **⋮ → Edit Query** opens its SQL on the Search page. This is the widget's private copy, not your original saved query, and it is not listed in the Query Library. Saving takes you back to the dashboard and updates only that widget.

If the dashboard has a cached result less than 24 hours old, Search shows that result first, under the banner *Showing results from a cached run…*. Select **Run Query** to get fresh data.