我的数据集包含以下列:- person_ID - brand - purchase_date 现在,我想使用Google Data Studio创建一个仪表板,显示购买了X品牌的人还购买了哪些其他品牌。 with identification as
(
select person_ID
where brand = 'X'
from dataset
)
select count(distinct(data.person_ID)), data.brand
from dataset data
inner join identification ident on data