Hey Looker Community -
I’ve been trying to use an AND operator when applying a filter in a simple Dashboard Tile, and I haven’t been able to. When I Merge Results, I can’t get the visualization I’m looking for. If this was straight SQl, I’d create a View and then query the view to get the result I want, but that doesn’t work in dashboard tiles.
Essentially, I have a set of Users, and they can be in several Groups. A simple query will just show the user, a group they are part of, and then repeat the same user and a different group on a new line.
I’m trying to find a set of users that are in two specific Groups. So sorry if my question isn’t clear, I’d really appreciate the help!