Forum Discussion

pmazara's avatar
pmazara
Frequent Visitor
6 years ago
Solved

How to create a pivot from 2 columns (source table) - note attached screenshot

Trying to create a pivot from 2 columns (from source table) -> note that the second column has repeat enteries

 

Need to DistinctCount the skill type against each user so as to create a pivot per custom Table 2 

 

This is to satisfy the data format required for the venn visual

 

Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi there - 

     

    I have tried using the sample data attached in your screenshot and tried to get the output you were looking for. Please find the file uploaded here - https://drive.google.com/file/d/1nVIXsZaHUkOsB4_S3kex9_pVuE7QNvD6/view?usp=sharing

     

    Once accessed, please let me know so that I can delete the file from there. If the above solution helped you, please accept this as a solution.

     

    Regards

    E

    • pmazara's avatar
      pmazara
      Frequent Visitor
      6 years ago

      Hi E Anonymous,

       

      This is great. Just need your help with one more step to complete the solution -> how to get distinct count for each skill type ?

       

      The Venn visual only works with binary values

       

      Thanks,