I'm working on a behavioral inspection form, and I have some multiple choice items, like:- Movement: running on the stairs, walking outside the safety lane, etc.- Position: body projection, sitting on machinery, etc.I want to group in a virtual colum...

Hello!i'm having problems filtering strings in this pattern: Data1, Data2, Data3. I have cells with grouped tags, and need to count 'em separately. I tried to use CASE with REGEXP_CONTAINS or CONTAINS_TEXT setting the tag text, but it's only counting...

I have a spreadsheet with the Google Forms response base, and some of the items are multiple choice, which end up being grouped in the cells.I need Looker to be able to count each choice separately, but what it's doing is counting all values ​​as uni...