I am trying to build a dashboard on Google Data Studio that automatically filters the data based on the user who is accessing the dashboard (using their Google account credentials). Here is some details: So this dashboard is supposed to show some aggregated data for employees but we want to limit the visibility and implement some access control so that each leader can only see the results for their own team. Below is a sample data set and a sample dashboard. I have tried creating filters based on leaders but couldn't find a way to link that to how the dashboard is being rendered.

P.S. I have a good understanding of JavaScript if there is a workaround using Google Apps Script. This dashboard will be deployed to a webpage on Google Sites so maybe we can control and manage the access that way.

Data Set (