Data driven default value in filter

Looker Q&A Looker
1

I have a dashboard in which I am showing orders from all departments for a user.

The stakeholder wants to default the orders to the user’s department and provide the user option to select other departments from the filter if they wish to see data for other departments.

e.g. if the user is in Marketing then the tile should default to show orders from Marketing and the user should have the option to choose other departments from a filter to see orders from other departments

I have added a department filter on the dashboard but I cannot figure out how to default the filter to the user’s department

Any ideas

1 Like
2

There is one way to put more than one type a filter. If you share a print screen with your idea I can teu help you.

3

A cheeky work around is it make copies of the report, and set the filter button to the respective department for each report copy. Then it should always be the same depending on the link.

The only issue that I see with this, is having to add or change graphs on the report and copies in the future could be annoying.

Let me know if this works for you

4

Can you achieve this using user attributes:

  1. Get an Admin to create a user attribute called ‘department’.
  2. Get an Admin to assign user attribute values to your users (e.g. all users in the user group ‘marketing’ have a user attribute value of ‘marketing’).
  3. In your dashboard, add a filter:
    • Filter by = <select the ‘department’ dimension from your Explore>
    • Control = Advanced
    • Configure Default Value = matches a user attribute > select the ‘department’ user attribute
5

@muriloagu Attached is the screenshot. I have tried to explain my needs in the screenshot

Xnip2025-06-16_10-41-49.jpg
Xnip2025-06-16_10-41-49.jpg1753×803 91.2 KB

6

Thanks for the suggestion. Unfortunately that will not work for us

7

I did think about that. The issue is that the user keeps changing departments quite frequently. We would have to write a API call to update the user_attribute regularly.