Anyone know how to display ROI from data in two unlinked tables?

Anyone know how to display ROI from data in two unlinked tables?

We've been working on this issue with support for weeks but have gotten no where.

We're looking for something that seems so simple; a widget in a dashboard that shows the ROI for ad spend (ROAS). Table A has the ad spend cost. Table B has the revenue. We have tried several ways to link them via lookup columns, but nothing has worked. Support has tried to create query tables, but it's proven more challenging than they anticipated.

We can't link the tables because they have no columns of data in common. We've tried adding a formula column to simply print generic pre-defined text, but support had no idea how to do that. You can't link a formula column to another formula column, so that option is out.

The correct spend and revenue values are easily added as widgets in a dashboard, but you can't create another widget that simply divides widget A by widget B.

It's so frustrating because it seems like a really common requirement for a business using Zoho Analytics. Any advice would be greatly appreciated.
    • Sticky Posts

    • What's New in Zoho Analytics - January 2026

      Hello Users! We are starting the year with a strong lineup of updates, marking the beginning of many improvements planned to enhance your analytics experience. Explore the latest improvements built to boost performance, simplify analysis, and help you
    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's
    • 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.