I'm a new user to Tableau and am trying to play around with data from the 2016 US Election. I wanted to do the following things but am having trouble:
1. In the first sheet (Vote by State), I am hoping to show the candidate who has the highest percentage of votes in the state.
2. In the second sheet (Total vote), I am hoping to show the votes for the candidate as a percentage of total population polled. The PST045214 column has the population for each state.
I'm pretty stuck on doing both of those. Could you please let me know how I can go about doing both on Tableau?
Take a look at the following resources, they may be helpful:
Quick Table Calculations