I have a worksheet in Tableau 8.0.2 and I am trying to count the number of members of 2 different types and display a ratio of one to the other by Canadian Post Codes.
I eventually would use the ratio on a map to show where we have sub-optimal ratios.
I started by creating 2 calculated fields that simply counts each type (they are identified by an attribute that is on the dimensions) and then do a second calculated field that just divides one by the other.
Unfortunately I can't get the division to calculate at all. If I use the exact same setup but put a + between the fields it calculates as I would expect.
What am I doing wrong?
We need more information to answer your question. You'll need to post more details such as a Tableau packaged workbook with sample data that represents your situation, and ideally a mockup of your desired results. For an explanation why, see http://community.tableau.com/docs/DOC-5065.