Sure, I can try to help. After loading up your data, to get the medal count by nation you will need to start by creating a calculated field to denote which ranks correspond to which medals. Something like
[Medal] : IF [Rank] <= 3 THEN [Rank] END
This new field is null if the contestant did not receive a medal, 1 for gold, 2 for silver, or 3 for bronze. You will want to convert this new field to a dimension as opposed to a measure. You can then put your [Country] field in the "Columns" shelf and COUNT([Medal]) in your "Rows" shelf. If you want the top 5 or top 8 countries, you just need to put [Country] in the "Filters" card and in the "Top" tab, select under "By field": Top 5 (or 8) by COUNT([Medal]).
I would encourage you to play around with the chart a bit. You could try adding some extra filters, or breaking down the medal counts by medal type. Plenty of things you could do with this.
I agree with Stephen. This is usually a really fun data set to play around with and would also suggest you search Tableau Public to see what others have done with the data and reverse engineer how they built some of their dashboards.
If you wanted to modify Stephen's calculation, you can also do this:
IF [Rank] = 1 THEN 'Gold'
ELSEIF [Rank] = 2 THEN 'Silver'
ELESIF [Rank] = 3 THEN 'Bronze'
ELSE 'Did not medal'
You can use this as a KPI on your color mark to really bring out the successes of countries and individual athletes for comparison.
Thank you for this. I look forward to playing around on Monday!
Good idea with KPI. Day one of Tableau and I do not have a background in computer science or programming, glad it is easier to grasp. Thank you.