Documentation › Charts
Time ranges and filters
Set a chart's time range with presets, relative periods or exact dates, and filter rows with simple or custom SQL filters.
Time range
Every chart on a dataset with a date column has a Time range filter. By default it is No filter, which means all dates. Click it to choose:
- Last
- Last day, Last week, Last month, Last quarter, Last year: the period ending today.
- Previous
- Previous calendar week, Previous calendar month, Previous calendar year: whole periods before the current one.
- Current
- Current day, Current week, Current month, Current quarter, Current year: from the start of the period to now.
- Custom
- A start and an end, each either a Specific Date/Time or Relative Date/Time such as 30 days before now.
- Advanced
- Free text such as
DATEADD(DATETIME("today"), -6, month)totoday, or2026-01-01to2026-07-01.
The start is included and the end is excluded: 2026-01-01 ≤ col < 2026-02-01 is the whole of January.
Which date column the range applies to is the dataset's Default datetime column, or the column you put on the X-axis. See Column settings.
Time zone
Embiro BI compares dates as they are stored in your database. If your timestamps are in UTC and you report in Kampala time (UTC+3), convert them in a calculated column, for example in PostgreSQL order_ts AT TIME ZONE 'UTC' AT TIME ZONE 'Africa/Kampala'.
Time grain
On time-series charts, Time grain groups dates into periods: minute, hour, day, week, month, quarter or year. Weeks start on Monday.
Filters
Filters on the Data tab keep only the rows you want.
- Simple
- Pick a column, an operator and a value:
regionequal toCentral,branchinKampala Road, Ntinda,revenue_ugx>0,customerIS NOT NULL, orproductLIKE%Sugar%. - Custom SQL
- Type a condition as you would after
WHERE, such aspayment_method IN ('MTN MoMo', 'Airtel Money') AND revenue_ugx > 0. Choose HAVING instead of WHERE to filter on an aggregate, such asSUM(revenue_ugx) > 1000000.
Filters saved in a chart always apply. Viewers change what they see with dashboard filters, which apply on top.
Dataset parameters on charts
If a chart's dataset was saved from a SQL Lab query with parameters, such as {{ region }} or a date range {{ period }}, the chart shows those parameters as filters inside its card on dashboards. See Parameters and date ranges.
To filter on a second date, such as a due date, while the time range stays on the main date, use a date-range parameter: see Filter a chart by due date.
Something unclear or missing? Tell us and we'll improve this page.