Common dashboard for different users/companies

Hello, a question regarding looker features.

Is it possible to have a one dashboard and according to the company/user it render the same dashboard but with the company data.

Will try to make it clearer, imagine we have different companies with different data sources and we want to have one dashboard but depending on which company is seeing the dashboard it can render that company specific data?  

Solved Solved
0 1 258
1 ACCEPTED SOLUTION

Dawid
Participant V

Yes, you can do that using User Attributes and access Filter feature on an explore level:

explore: customer {
access_filter: {
field: sales.region
user_attribute: sales_region
}
}

This code, for example will automatically filter your source by sales.region and take the value set in a user attribute called “sales_region”. One thing to remember is that even Admins have to have a value for this (most probably NULL to allow for all).

You can find more information about this here: https://cloud.google.com/looker/docs/reference/param-explore-access-filter

View solution in original post

1 REPLY 1

Dawid
Participant V

Yes, you can do that using User Attributes and access Filter feature on an explore level:

explore: customer {
access_filter: {
field: sales.region
user_attribute: sales_region
}
}

This code, for example will automatically filter your source by sales.region and take the value set in a user attribute called “sales_region”. One thing to remember is that even Admins have to have a value for this (most probably NULL to allow for all).

You can find more information about this here: https://cloud.google.com/looker/docs/reference/param-explore-access-filter