🌐Applying global filters

Global filters apply consistent filtering across all tabs within a Vizpad. Any filter configured at the global level cascades to every chart and tab in the Vizpad, ensuring uniform data context across the entire dashboard.

  1. In a Vizpad, click on the Add Filter button and the following menu will be displayed.

  1. Click on the Applied to option to determine the charts for which you will apply the filter.

  1. If you want to apply a global filter (for all charts in all tabs), then select All charts in the Vizpad. All subsequent filter configurations apply to every Vizpad tab.

  2. If you want to apply filters all the charts in the current tab, then select All charts in the tab.

  3. If you want to apply the filters only to specific charts, then select Selected Charts in this tab.

Once you set up the filter to be applied, then the following panel appears along with checkboxes for each chart/table in the current tab.

You can select the required charts and the count will be increased accordingly in the panel. Select all selects all the visuals in the tab, and the filter will be applied to the selected charts once you click on Apply.

  1. If you want to apply filters to any date columns, then enable the Date filter toggle.

When Date filter toggle is disabled, only measures and dimensions will be displayed in the Select Column dropdown. If it is enabled, then only date columns will be displayed in the Select Column dropdown.

  1. Once All charts in the Vizpad is selected, then the minimum and maximum range will be auto-selected. However, it overrides manual range modification so you can make necessary changes as required.

  2. The auto-range will be selected as follows:

    1. Measures: Selects the minimum and maximum values of the measure.

    2. Dimensions: Defaults to IN (inclusion) operator.

    3. Date columns: Calculates MIN(date_column) to MAX(date_column) from entire dataset.

  1. Enable the Use Alignment Mapping toggle if you want to refer only the mapped measures. This will be displayed only if Date filter is enabled.

  2. Click on the Select time period field and the following window will be displayed. The available Measure → Date mappings for the Business View will be listed.

  3. Choose the required time range from the available list.

  1. Click on Apply to save the changes. The date filter will be applied to the selected chart(s).

To set up new Measure → Date mapping(s) or to edit the existing mappings, please check out this page.

Because you mapped Sales, Quantity, Discount → Order_Date and chose Last year with Date mapping enabled, Tellius first kept only the rows whose Order_Date fell in last year. Then it aggregated by Category.

Without mapping, the time filter could have hit a different date column or been applied across measures. Mapping forces the filter to use the correct date per metric, so your bars and lines are apples-to-apples for “last year.”

PreviousCreating VizpadsNextFilters in multi-BV Vizpads

Last updated

Was this helpful?