How to: Multiple user attribute values (OR logic)

Looker Tips & Resources Technical Tips & Tricks
1

Knowledge Drop

Last tested: May 20, 2019

Use a String Filter (advanced) user attribute type and input the user attribute values with the following syntax:

'value1','value2'

Each value should be wrapped with single quotes and delimited with a comma. Make sure there are no white spaces between the values.

2

Is this syntax still valid? We tried it out for our region field, with user attribute set to:

‘US’,’EU’

Single quotes, delimited with comma, no white spaces.

But we get No Results from the query.

3

@Andreas_Granstr

It looks valid. Did you select String Filter (advanced)?

cloud.google.com/looker/docs/admin-panel-users-user-attributes

String Filter (advanced): Select this option to allow multiple string values or a Looker filter expression in the user attribute. See the Filter expressions documentation page for a list of filter expressions you can use for strings.