I'm relatively new to Tableau and I have 2 data sets, one from 2016 olympics and one from 2020 olympics.
I want to compare the results from 2016s "Total" amount of medals for each country against the 2020 olympics "Total" amount of medals achieved by each country.
This is assigned by the "Total" value within my data set as shown in the screenshot
In Tableau when I create a sheet and input the "Names" and "Total" medal count, it displays the information correctly for the 2016 data with the Total amount of medals achieved by each country.
Although, when I try to include 2020s Olympic data to compare against, it displays the wrong number as it should be displaying "24" for Canada but displays as 1.
Not sure if I should be including any extra fields onto this sheet which is why I am here to ask, is there another way I could do this to where I can get the correct results displayed back to me?