5 Replies Latest reply on Apr 3, 2018 11:04 AM by Deepak Rai

    Comparison of data with multiple questions on different rows to find Percentages

    Wendy Weber

      How to do a comparison of data by Employee ID for 2 different rows where there are multiple questions? I want to compare data for only 2 of the 4 questions which is "now" and "later".  I would like to compare the first 2 rows for each employee where the flag =1 for the same employee ID and for the same food item selected.   So for this scenario based on the Tableau Package attached it would be 2 out of 5 people met this criteria since employee #4 selected hamburgers for both choices and employee #5 selected Ice cream for both choices for questions "now" and later".

       

      Since employee #4 and employee #5 have their flag =1 for the same food item the total number of employees that qualify are 2 out of 5  or 40% of the employees prefer the same food "now" and "later".  

       

      I tried entering a filter to only select questions "now" and "later" but it didn't produce accurate results.