How to divide values from two different tables to create a ratio in a dashboard

How to divide values from two different tables to create a ratio in a dashboard

Hi there,

My name is Carolina and I tried to search on the community and online how to do a simple division in a dashboard, but I couldn't find an answer for that.

For example: What I need to do is divide the Total Installations (134) by Total Appointments (2502) and result in the percentage, but when I do the filters the percentage should update with the values. As observation, this numbers from installations and appointments are coming from different tables and join them in a query mess the values (even with filters).

So I would like to know if there is any widget or formula on the dashboard where I could do this simple percentage dividing numbers that are on the dashboard, please.
 
If you need any further information, please let me know.

Regards,
Carolina
    • Sticky Posts

    • Tip of the Week - Spot Risky Sales with Conditional Formatting

      In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to apply