3 Replies Latest reply on Feb 24, 2016 6:51 PM by Shinichiro Murakami

    Facing problem in using the data from two columns

    Chandan Mishra

      In the match data, there are two person id's. Whoever who has grad year <=2015 will be considered as an alumni while all the person with grad year>2015, will be considered as the student. Now, I have to find the number of records for alumni-alumni matches, student alumni matches. So, for alumni alumni matches, if I am selecting person id as 9 for person 1, it gives me only 7 records even though it has two records in person 2 as well. So, the total should be 9 records in tableau but how to show it. Also, I have to match the names of the person in match data with person names date for which I used inner join. Please give me a chart on how to proceed correctly on this. Thanks