Hey Luke, thank you for your Tableau videos (as well). I am trying to figure out what to do when I have fields with zeros, then the bar chart method doesn't work.
That's a great question, here is the difference: CNT = Count - is an aggregation method that counts ALL the occurrences for a chosen variable (no matter whether it repeats or not). So in the video if we would have done Count on 'Name' we would have had a few thousand values for each of the names, because the names appear a few thousand times in the data source. (Every cell would have had different varying size bar charts in this case. This was not what we wanted in our case, we needed a consistent value across all rows and columns (i.e., 1) to get the bar chart to be the same size in every cell) CNTD = Count (Distinct) - is an aggregation method that counts a single occurrence of a variable (it does not count repeats). So we use CNTD in the video to count the 'Name', because we know (with how we have made the table) that the 'Name' only will appears once in each row. Hope this helps!