Embiro BI

Documentation › Dashboards

Dashboard filters

Add filters to a dashboard - values, time ranges, numbers - plus cross-filtering, drill-down and per-chart parameter filters.

Dashboard filters let viewers narrow every chart at once: pick a region, a branch or a period, and the charts follow.

Add a filter

Who can do this: Super Admin, Admin and Analysts (anyone who can edit the dashboard).

  1. Open the dashboard. The filter bar is on the left. If it is collapsed, click the arrow.
  2. Click the gear icon at the top of the filter bar → Add or edit filters and controls. The Add or edit display controls window opens.
  3. Click + New → Add filter.
  4. Choose the Filter type:

    Type Use it for
    Value Picking from a column's values: region, branch, product, sales agent
    Time range Choosing a period: Last month, a custom range
    Time column Letting viewers switch which date column the time range applies to
    Time grain Switching charts between day, week, month and year
    Numerical range A slider for a number column: order value, age
  5. Give it a Filter name viewers will understand, such as Region.

  6. Choose the Dataset and Column.
  7. Set the options you need (see below), then click Save.

The Add or edit display controls window, setting up a Value filter named Region on the region column of the sales dataset

Useful options

  • Filter has default value: applied when the dashboard opens, such as Current year.
  • Can select multiple values: on by default for Value filters.
  • Filter value is required: viewers can't clear it.
  • Select first filter value by default.
  • Sort filter values: alphabetical, or by a metric.
  • Values are dependent on other filters (under Advanced): the Branch list then only shows branches in the chosen Region.
  • Scoping (the second tab): which charts the filter applies to. By default it is every chart whose dataset has the column. Charts on other datasets are left alone.

Dividers

+ New → Add divider adds a heading with a short description between groups of filters, such as Location and Period.

Using filters as a viewer

  1. Choose values in the filter bar.
  2. Click Apply filters. Charts update together.
  3. Clear all resets the filters to their defaults.

Choosing Central in the Region filter and clicking Apply filters: every chart follows.

The chosen filters are part of the address: share the URL and colleagues see the same selection.

Cross-filtering

Click a bar, a pie slice, a table row or a map area to filter the other charts on the dashboard by that value. The filter appears at the top of the filter bar under Cross-filters. Click it again, or × in the bar, to remove it.

Drill to detail and drill by

Right-click a data point:

  • Drill to detail shows the underlying rows behind that bar or slice, in a table you can page through;
  • Drill by regroups the chart by another column, for example from region to district within the region you clicked.

Chart filters from dataset parameters

Charts built on a dataset saved from SQL Lab with parameters (such as {{ region }} or a date range {{ period }}) show those parameters as filters inside the chart's card. They apply to that chart only:

  • change the values, then click Apply Changes (it shows how many filters changed);
  • your choices are remembered in your browser for that chart, and Reset restores the dataset's defaults.

A chart on a dashboard with its own order_period filter set to Last month

For a step-by-step example with a date range such as {{ due_date.start }} and {{ due_date.end }}, see Filter a chart by due date.

Something unclear or missing? Tell us and we'll improve this page.