Looker Studio Bible

Looker Studio Bible

Home
Connectors
Calculations
Data, blending & parameters
Data visualization
Dates
Design & navigation
Performances
About

Calculations

How to properly use the percentile function in Looker Studio
If you’re working with 3rd party connector or raw data, it’s likely your percentile formules don’t work. No worries, we’ve got a solution!
How to calculate the number of days in a month and monthly averages in Looker Studio?
Tricky formula, but outrageously powerful! In this article, we show you how to calculate the number of days in a month in Looker Studio
How to properly build calculated fields (sum, ratio, …) with blended data in Looker Studio?
So, this is a common issue we’ve seen. How to make sum of blended data work in Looker Studio? No worries, we’ve got a solution for you!
Some useful date formulas, formats, ranges, calculated fields… in Looker Studio
It’s all about dates. In this article we’ll share with you some useful date formulas, formats, ranges, calculated fields… in Looker Studio
How to calculate median, percentile, average with third-party connectors in Looker Studio
Average, median and percentile are not working for you in Looker Studio? No worries, we’ve got solution for you so they’ll work like a…
How to filter GA4 traffic in Looker Studio (Organic, Paid, …)?
Need to filter out GA4 Organic traffic from your Looker Studio dashboard? No worries, we’ve got you covered, we show you how to do it here
How to mix GA4 metrics and dimensions in Looker Studio? (Danger Zone!)
Want to mix GA4 metrics and dimensions in Looker Studio but the native connector won’t let you? Well, we’ve got a little hack for you !
How to split Analytics conversion by Search Console keywords in Looker Studio?
Split your Analytics conversion by Search Console keywords in Google Looker Studio to optimize your SEO!
How to display Facebook Ads and Google Ads metrics in the same table in Looker Studio?
Tired of having different tables for Facebook Ads data, Google Ads data, ….? Here, we’ll show how to display all metrics in the same table
How to replicate SUMIF, AVERAGEIF and COUNTIF functions in Looker Studio?
You’re the king of SUMIF, AVERAGEIF and COUNTIF in Excel, but can’t make them work in Looker Studio? No worries, we’ve got it covered for…
How to split a string that has comma or pipe delimiters using REGEXP_EXTRACT in Looker Studio?
Can’t find the formula again? Same thing happens to us all the time, so we wrote this article to help you split strings using…
How to build calculated fields in Looker Studio and what are the most useful formulas?
Learn how to build calculated in Looker Studio so your dataset is not a limitation anymore, and use formulas to make best use of your data
© 2025 Looker Studio Bible
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture