Home Glossary Zoho Analytics Dynamic Filter
Zoho Analytics

Dynamic Filter

A Dynamic Filter in Zoho Analytics is a filter mechanism where the selected value in one report or widget automatically filters the data shown in other lin

Technical Term

Dynamic Filters turn charts and tables into interactive navigation controls. The source chart broadcasts a filter condition based on what the viewer clicked, and all linked target reports apply that condition to their data query.

How Dynamic Filter Works in Zoho Analytics

A Dynamic Filter in Zoho Analytics is a filter mechanism where the selected value in one report or widget automatically filters the data shown in other linked reports on the same dashboard, enabling contextual drill-through exploration.

When to Use Dynamic Filter

Use Dynamic Filter when your reporting requirements go beyond what built-in defaults provide. This feature is most valuable for organisations that have moved past basic data viewing and need precise control over how their data is organised, queried, or presented. Teams working with multiple data sources, varied user groups, or complex business logic will find this capability central to their Zoho Analytics setup.

Key Considerations for Dynamic Filter

Before configuring Dynamic Filter, ensure that the underlying data tables are clean and consistently structured. Irregular naming conventions, mixed data types in a single column, or missing values can produce unexpected results. For shared environments, coordinate with your Workspace Administrator before making changes that affect reports used by other team members. Testing on a duplicate report before applying changes to production dashboards is a sound practice.

India Example: A sales performance dashboard has a region map as the source chart. Clicking ‘South India’ on the map dynamically filters the sales rep performance table and the monthly trend chart below to show only South India data.
What is a Dynamic Filter in Zoho Analytics?

A Dynamic Filter links reports on a dashboard so that clicking or selecting a data point in one report filters the data in other reports. For example, clicking a bar in a region chart filters a detail table to show only records from that region.

How do I set up a Dynamic Filter in Zoho Analytics?

In the dashboard editor, select a chart and configure its interaction settings to act as a filter source. Define which column it filters on and which other reports on the dashboard should respond. When viewers interact with the source chart, linked reports update automatically.

Need help implementing this in Zoho?

Aaxonix is a certified Zoho implementation partner based in Pune. Architecture-first, no surprises.