Issues with Dashboard Filter and KPI in Zoho Analytics (CAGR)

Issues with Dashboard Filter and KPI in Zoho Analytics (CAGR)

Hi everyone,
I'm trying to build a CAGR (Compound Annual Growth Rate) KPI in Zoho Analytics, but I'm running into some issues with filter synchronization.

Here's the scenario:

  • I created two test reports:

    1. One that filters results from 2021 to 2025.

    2. Another that combines data across all years (a kind of “all vs all” setup for CAGR calculation).

The problem is:

  • The Dashboard filter (e.g., year) does not apply to the KPI.

  • I tried relating the columns from both queries to force filter synchronization, but I get the message: "No matching columns".

Has anyone faced this issue or have any suggestions on how to fix it?
I'd really appreciate any help!

    • Sticky Posts

    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
    • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

      Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you