How do I calculate ratios using the data in two columns to create a ratio in Tableau?
- Tableau FAQs
- December 13, 2018
This is a fairly simple function to perform in Tableau, and to implement it, you need to use the following expression:
SUM([SalesQuota])/SUM([SalesYTD])
SUM([SalesQuota]) – here, you summarize the value of field A
SUM([SalesYTD]) – then you divide the sum of values from field A by the sum of values from field B
Up Next:
Read How to alter the selected column value based on the value of another column in SQL?