Group based on AND condition

SBH38 · 03-08-2023 12:21 PM

Hello all. First of all, love the new GROUP feature in Looker. Super helpful. I have a question about it though.

Per the image below, I’m looking to group URLs into one bucket. Let’s say there are pages of a site that have both “/view” and “sales-quote-creator” in the URL. Since the URL in question has BOTH of these parameters, an OR operator is not satisfactory. If we had the ability to swap the OR with an AND, it appears that this would solve my problem. Is this something that is on the roadmap? Would be super useful.

SBH38

Alternatively, if the CONTAINS clause was inclusive, meaning it looks for results that include /view AND sales-quote-creator.

SBH38

Bump. My 2 cents is that this is a really important feature that adds a lot of complexity to the group function and can, in some cases, make it unworkable.