Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Comparing data from 2 tiles

Hi All, was wondering if there is a way to compare data from 2 separate tiles and pull the data into a new tile.  

 

itmsibilly_0-1733950749821.png

 

0 1 109
1 REPLY 1

Very tricky! I've been thinking about ways to do this, but can't come up with anything easy.

In Looker Studio, all of the blend types include data shared between the two data sets. This would be a feature request.

In Looker, you could probably get at this with a SQL-based derived table. Something like:

SELECT column1 
FROM table2
WHERE column1 NOT IN (
SELECT column1
FROM table1
)

 

Top Labels in this Space
Top Solution Authors