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!