I’ve created a few metrics in the admin dashboard that are looking for a string within a txt field. They look like this:
query string contains “google” - count of rows
query string contains “bing” - count of rows
Query string as a field contains all sorts of things, and goal was to make new “binary” metrics for each, and then make a question that compares them all in a single table (Ie by Date show me how many rows I have that contain google vs. bing etc.)
The calculated fields work separately, but if I pull them both into a single question the query comes back null. It seems like the logic is being combined somehow. Am I doing something wrong? Is there another way to do this?