Forum Discussion
Solved
Dynamic axis based on user
Hi people, I want to create a visualisation of which axis change based on the logged-in user. In my organisation, there are managers and team leads with the following hierarchy. ...
I believe that you need a table like this:
ID Category Category 2 E-Mail Project - Team 1 Project Team 1 [email protected] Project - Team 2 Project Team 2 [email protected] Project - Team 3 Project Team 3 [email protected] Maintainance - Team 1 Maintainance Team 1 [email protected] Maintainance - Team 2 Maintainance Team 2 [email protected] Maintainance - Team 3 Maintainance Team 3 [email protected] Project - Team 1 Team 1 [email protected] Maintainance - Team 1 Team 1 [email protected] Project - Team 2 Team 2 [email protected] Maintainance - Team 2 Team 2 [email protected] Project - Team 3 Team 3 [email protected] Maintainance - Team 3 Team 3 [email protected]
You then connect it to a mapping table, with only distict ID's:ID Project - Team 1 Project - Team 2 Project - Team 3 Maintainance - Team 1 Maintainance - Team 2 Maintainance - Team 3
And then you connect the mapping table to your sales table.
Crossfilter direction "Both" on the relationships. And finally you apply RLS on the E-mail column of the first table.
This should mean that if you use the "Category" column you will only see departments as a DM, and only Teams as a TL.
What do you think?
Br,
J
