Forum Discussion
Creating a Line Chart Based by Supervisor
You probably need a 'lookup' table that has a unique list of Supervisor names and ID numbers. Use a relationship to join the ID numbers from both tables, then use the Supervisor name field in all your filters.
If the employee names in the Person table are identical to the implementer names in the Preventative Maintenance table, then you should be able to go to the Relationships view and drag a relationship from Implementer to Employee (see video).
Then, when you filter by Supervisor on a visualization, only employees with that Supervisor will appear.
Thanks for the video; that was awesome. Helps to see. Unfortunately the cell values are not the same, but your response got me to look at the data further; I found I needed another table to make the connection.
PERSON TABLE TO A LABOR TABLE (Which has a PersonID and Labor Code)
The Labor Code cell values are those named "Implementer" in the PREVENTATIVE MAINTENANCE TABLE.
So connection solved!
Now a new issue...the SUPERVISOR name that displays is the person's number, i.e., 12345, and not their name. Any tips on getting the Slicer to display their name?
You probably need a 'lookup' table that has a unique list of Supervisor names and ID numbers. Use a relationship to join the ID numbers from both tables, then use the Supervisor name field in all your filters.