Skip to main content

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.

ToTypeResult
Exact valuesite : "Site A"Only Site A collections.
Value without spacesshift : NightQuotes are optional when the value has no spaces.
One of several valuesshift : (Morning or Afternoon)Morning or afternoon collections.
Two conditions togethersite : "Site A" and status : "Rejected"Collections that meet both.
One condition or anotherstatus : "Rejected" or status : "Needs adjustments"Collections that meet at least one.
Exclude a valuenot status : "Approved"Everything except approved.
Field filled innotes : *Collections where the field has a value.
Field emptynot notes : *Collections without the field (unanswered or not yet evaluated).
Number greater than or equalperc-total >= 70Results from 70 up.
Number lower thanperc-total < 60Results below 60.
Number rangetemperature >= 0 and temperature <= 4Between 0 and 4.
Date fromdate >= "2026-01-01"Collections since January 1, 2026.
Relative datedate >= now-7dCollections from the last 7 days.
Starts withequipment : 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.

The value must be exact

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.

Field names with hyphens

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.

  1. Click Add filter (the + icon next to the search bar).
  2. Choose the Field.
  3. Choose the Operator:
OperatorMeaning
isEquals
is notIs different from
is one ofIs one of the values in the list
is not one ofIs none of the values in the list
is betweenIs between two values (numbers or dates)
existsThe field is filled in
does not existThe field is empty
  1. Choose or type the Value. The list suggests existing values.
  2. In Custom label, give the pill a readable name if you wish (for example, "Rejected only").
  3. Click Add filter.

Pill actions​

Click the pill to open its menu:

ActionWhat it does
Edit filterChanges field, operator, value or label.
Exclude results / Include resultsInverts the filter: shows everything except the chosen value. The pill gets the NOT prefix.
Temporarily disableTurns the filter off without deleting it. The pill appears struck through.
Pin across all appsKeeps the filter when switching screens (for example, from the dashboard to Discover).
DeleteRemoves 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​

RangeHow to configure
TodayCommonly used → Today
Last 7 or 30 daysCommonly 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 monthsStart 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 yearThis year (January 1 to December 31)
Fixed range (for example, a quarter)Start and end Absolute
What "rounded to the year" means

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

"Year to date" or "This year"

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​

FilterApplies toWhere to configure
Search bar and pills of the dashboardEvery chart in the dashboardTop of the dashboard
Dashboard controls (selection lists)Every chart in the dashboard that has the control's fieldControls
Dashboard time rangeEvery chart, except those with their own time rangeDashboard time picker
Search bar and pills of the chart editorOnly that chart, in addition to the dashboard filtersFilter for this chart only
Filter by on a metricOnly that metric (series) of the chartFilter on a metric
Chart's own time rangeOnly that chart, replacing the dashboard rangePer-chart time range
Pinned pill (Pin across all apps)Every screen, until removedPill menu
Filters add up

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.