1 Reply Latest reply on Oct 19, 2018 10:12 AM by venkatram

    How to calculate percentage of records that does have a value vs total

    Martyna Molak

      Hello Everybody

       

      I am  a Tableau beginner and I have a question which I hope some of you will be able to help me with.

       

      I have 2 data sets:

      1. List of the people with additional information about them (including department they are working for and their employee ID)

      2. List of all employee ID nthat have access to the system.

       

      What I would like to calculate:

      I would like to check what is the percentage of people who have access to the system and split it by department.

       

      The unique value present in both sets is Employee ID.

       

      I have done left join of those 2 data sets but I struggle with getting the calulation done.

      Maybe someone could advise on how to aproach that?