2 Replies Latest reply on Apr 9, 2018 6:47 PM by Mike Mainzer

    Counting the number times a record in one column matches/doesn't match the item in the same row of another column?

    Sarah Jellenc

      Hi! I'm new to Tableau, and am practising with a dataset about Nobel Prize winners. I've got one column with the country of birth for each winner (column B), and another with country of death (column D). I'd like to find the total number of winners who migrated -- that is, whose country of birth is different from their country of death. So, I need to count the number of instances in which an item in column B does not match the item in the same row of column D. Can anyone advise? (I'm working with Tableau Public.)