Search, filters and time range
Filtering is what turns a general dashboard into a specific answer. With a few clicks, the same dashboard shows only one site, only rejected audits, only the night shift or only the last quarter. Filters can be typed in the search bar, chosen from lists, created with a click on a chart or saved with the dashboard so they apply every time it is opened.
This page explains the three filtering tools (search bar, filter pills and time picker) and the scope of each: the whole dashboard, one chart or a single series.
Search bar
The search bar appears in Discover, in dashboards and in the chart editor. It uses a simple language, shown on screen as KQL: the field name, a colon and the value.
| To | Type | Result |
|---|---|---|
| Exact value | site : "Site A" | Only Site A collections. |
| Value without spaces | shift : Night | Quotes are optional when the value has no spaces. |
| One of several values | shift : (Morning or Afternoon) | Morning or afternoon collections. |
| Two conditions together | site : "Site A" and status : "Rejected" | Collections that meet both. |
| One condition or another | status : "Rejected" or status : "Needs adjustments" | Collections that meet at least one. |
| Exclude a value | not status : "Approved" | Everything except approved. |
| Field filled in | notes : * | Collections where the field has a value. |
| Field empty | not notes : * | Collections without the field (unanswered or not yet evaluated). |
| Number greater than or equal | perc-total >= 70 | Results from 70 up. |
| Number lower than | perc-total < 60 | Results below 60. |
| Number range | temperature >= 0 and temperature <= 4 | Between 0 and 4. |
| Date from | date >= "2026-01-01" | Collections since January 1, 2026. |
| Relative date | date >= now-7d | Collections from the last 7 days. |
| Starts with | equipment : FL* | Values starting with "FL". |
| Group conditions | (shift : Night or shift : Overnight) and not status : "Approved" | Parentheses define the order of conditions. |
| Record source | _index : *site-a* | Records from the index whose name contains "site-a". |
As you type, the bar suggests field names and values. Press Enter or click Refresh/Update to apply.
In option fields, the value is compared letter by letter, including case and accents: status : "rejected" does not find "Rejected". Check the spelling in the field summary in Discover. See Find a field and see its values.
Names with hyphens, such as perc-total-5s, work normally in the search bar. Names with spaces or special characters require a \ before the character, so the standard of names without spaces or accents makes filters easier to write. See Question name.
Filter pills
Filter pills sit below the search bar and are built without typing an expression.
- Click Add filter (the + icon next to the search bar).
- Choose the Field.
- Choose the Operator:
| Operator | Meaning |
|---|---|
| is | Equals |
| is not | Is different from |
| is one of | Is one of the values in the list |
| is not one of | Is none of the values in the list |
| is between | Is between two values (numbers or dates) |
| exists | The field is filled in |
| does not exist | The field is empty |
- Choose or type the Value. The list suggests existing values.
- In Custom label, give the pill a readable name if you wish (for example, "Rejected only").
- Click Add filter.
Pill actions
Click the pill to open its menu:
| Action | What it does |
|---|---|
| Edit filter | Changes field, operator, value or label. |
| Exclude results / Include results | Inverts the filter: shows everything except the chosen value. The pill gets the NOT prefix. |
| Temporarily disable | Turns the filter off without deleting it. The pill appears struck through. |
| Pin across all apps | Keeps the filter when switching screens (for example, from the dashboard to Discover). |
| Delete | Removes the filter. |
Filter by clicking on a chart
In a dashboard, clicking a bar, slice, cell or point creates a filter with that value, and every chart recalculates. To go back, remove the pill that was created. In charts with dates on the horizontal axis, clicking and dragging over the chart narrows the time range to the selected stretch.
Time range
The time picker (calendar icon, right of the search bar) defines the date range analyzed, based on the data source's time field.
Ways to choose the time range
- Commonly used — ready-made shortcuts such as Today, This week, Last 7 days, Last 30 days, Last 90 days and Last 1 year.
- Quick select — builds a relative range: Last or Next, a quantity and a unit (minutes, hours, days, weeks, months, years). Click Apply.
- Recently used date ranges — ranges used recently.
- Start and end dates — click the start or end date to choose between:
- Absolute — a fixed date and time on the calendar.
- Relative — a date relative to now (for example, 3 months ago), with the Round to the … option to round to the start of the unit.
- Now — the current moment.
- Refresh every — refreshes data automatically at each interval, useful for dashboards shown on a TV.
Most used ranges
| Range | How to configure |
|---|---|
| Today | Commonly used → Today |
| Last 7 or 30 days | Commonly used → Last 7 days or Last 30 days |
| Current month (from the 1st until now) | Start Relative: 0 months ago, with Round to the month. End: Now |
| Last 12 complete months | Start Relative: 12 months ago, rounded to the month. End Relative: 0 months ago, rounded to the month |
| Year to date (January 1 until now) | Commonly used → Year to date. If the shortcut doesn't appear, use Quick select → Last 0 years and select rounding to the year, or choose Last 0 years rounded to the year in Recently used |
| Whole year | This year (January 1 to December 31) |
| Fixed range (for example, a quarter) | Start and end Absolute |
"Last 0 years" means "now minus 0 years", that is, now. "Rounded to the year" pulls that date back to the start of the year. The result is the range from January 1 until now: year to date. The same applies to month, week and day.
This year runs until December 31. In a month-by-month chart, it shows future months as empty. For cumulative figures, prefer the range until now (Year to date or rounding to the year).
Where each filter applies
| Filter | Applies to | Where to configure |
|---|---|---|
| Search bar and pills of the dashboard | Every chart in the dashboard | Top of the dashboard |
| Dashboard controls (selection lists) | Every chart in the dashboard that has the control's field | Controls |
| Dashboard time range | Every chart, except those with their own time range | Dashboard time picker |
| Search bar and pills of the chart editor | Only that chart, in addition to the dashboard filters | Filter for this chart only |
| Filter by on a metric | Only that metric (series) of the chart | Filter on a metric |
| Chart's own time range | Only that chart, replacing the dashboard range | Per-chart time range |
| Pinned pill (Pin across all apps) | Every screen, until removed | Pill menu |
A chart with its own filter still follows the dashboard filters. For example: the dashboard filters Site A and the chart filters status : "Rejected". The chart shows Site A's rejected collections.
Save filters with the dashboard
The search bar and pills active when the dashboard is saved are stored with it and come back every time it is opened. Before saving, remove filters used only for testing. The time range is only stored if Store time with dashboard is selected. See Save the dashboard.