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?
Created Sample Report:
or I can applied fixed calculations as well.
or if you want any specific requirements, please share dummy data or .twbx file for better understanding your requirements.