Learn how to create a pie chart that shows new vs. returning users using ninja Looker Studio techniques including custom fields, blending data with a full outer join and the mysterious COALESCE function. Find an introduction to blending data in Looker Studio here: And view our blog for written instructions & code snippets: 00:00 Intro 01:48 The problem with GA4's returning users metric 05;15 A donut chart using Google's metrics 06:47 A different way of calculating returning users 08:07 Creating a new & returning users blend 09:40 A donut chart using our new metrics 11:33 The magic of a full-outer join + COALESCE()