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