2 Replies Latest reply on May 11, 2018 9:41 AM by Tam Nguyen

    Compare and count unique sets of value

    Tam Nguyen

      Hello Tableau Forum,


      I've a question on how to compare and count unique sets of values.


      In the sample data below, there're 4 workbooks, and the permission names are people who have permission to view the workbooks.


      In the 'Workbook Permission' worksheet, I calculated for how many workbooks have number of permissions. That is, there're one workbook with 2 permissions and three workbooks with 3 permissions.


      Question: For workbooks that have same number of permission names, how to compare and count for unique sets of permission names? 


      For example, Inventory Report and Sales Report have 3 permission names and the names are the same. However, Profit Report also has 3 permission names, but this set of names are different from the sets for Inventory Report and Sales Report.


      So the result should be for workbooks with 3 permission names, there're two workbooks that have the same set of permission names and one workbook with another set of permission names.


      Looking forward to your solution.





      workbook permission data.png