In an explore, how can I get statistics of a single table correctly without being impacted by other tables it is joined with?

icy1
New Member

So I notice that in an explore, even if I just want to get stats of a single table only, when querying Looker still joins that table with another table (that I defined in the model) and the base table as well. That resulted in missing data of the single table if I don’t do full outer join. Is there a solution to this besides using outer join? I’m also curious whether this is a common use case for others? 

0 1 119
1 REPLY 1
Top Labels in this Space