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.