Embiro BI

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) to today, or 2026-01-01 to 2026-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: region equal to Central, branch in Kampala Road, Ntinda, revenue_ugx > 0, customer IS NOT NULL, or product LIKE %Sugar%.
Custom SQL
Type a condition as you would after WHERE, such as payment_method IN ('MTN MoMo', 'Airtel Money') AND revenue_ugx > 0. Choose HAVING instead of WHERE to filter on an aggregate, such as SUM(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.