Count the number of occurrences and their relative % in the column
I currently have a data frame with a column of Yes/No values that basically tells if a template was used to an...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
LEAD() & LAG() function in Looker Studio
Hi,Do we have Lead() & Lag() functions in the Looker Studio fields?if not then what are the alternatives which...
GA - Looker studio sampling
Hello, we are encountering sampling GA4 data in Looker Studio. According to the support, Looker Studio current...
How to connect Looker with Google Slides? (for our business reviews)
I'm looking for a way to connect Looker with Google Slides to automate our Weekly Business Reviews. Their prep...
Changing bar width of a bar chart
Is it possible to change the width of the bars in a bar chart?I have been looking at LookML parameters to chan...
Looker - Can an end user access a hidden measure?
So in our team we occasionally add dimensions that are useful but not commonly used as "hidden:yes". This is t...
Nested if condition in filters
Hi , Can looker support nested If condition in custom filters. for example , if I have several categories of d...
column order in Looker
The column order in the visualization is different from the column order that I define when I drag the column ...
How to upgrade to Looker Pro?
I've been trying to upgrade to Looker Pro for weeks now, multiple support requests and trying to contact sales...
How to create a custom Drop down menu containing User Metrics
Hi there! How can I create a custom Drop down menu containing only ‘Total Users’, ‘Sessions’ and ‘Views’? the ...
Calculating actual metric difference p/p instead of % delta only
hey all,I've been working on creating a few pivot graphs in Looker Studio to better review the data from GA4. ...
Changing a Date to School Year
In sheets, if I want to change a date to a school year (01/01/2024 is actually 2023-24), I write this formula=...
Text size in fixed-size control
When you create a "Fixed-size list" control, it is impossible to change the size of the header and the text, b...
AND/OR filters are not wrapping and making filters messy
Hi team, The AND/OR filters are a welcome feature but the reading the filters with medium/long labels are a pa...
Looker Studio Pivot Table Calculations Not Working
I'm using Looker Studio and needing to build a report that shows the Users, The status of their projects, The ...
Looker only showing half rows
We thought it was the date format, we tried parsing data, etc, no matter what we do only the previous months s...
Find Prior procedure start time (surgery) for the same room same Doctor
I am trying to find the prior procedure (surgery) end time for the same room, Same day, Same surgeon same surg...
Is there a workaround to report on the Exits metric which is missing in Looker Studio?
GA4 has the metric Exits available to report on. However, this is not (yet?) available in Looker Studio.To rep...
How to create a metric from a filter
Hello everyone,I created a dashboard on Looker to collect the clicks on different items on my website. I found...
Create a custom measure with fields from 2 different views
I am trying to create a custom measure to calculate the days from when a customer first signed up to when they...
Row totals not applying conditional formatting
Avg Age Row Totals not applying Conditional FormattingIn the above, I’ve added row totals to calculate the...
How to get Looker to accurately parse comma separated values
I am totally stumped.I am using a Sheet as my data source for a chart in Looker.This Sheet is receiving Form r...
How to keep the dashboard and Looks ID same across multiple looker instace
Hi,We have two looker instances. We have dashboards from where we drill out to another dashboard or looks. The...
How to create a table for multiple URLs with views over year/month period?
Hi,I'd like to create a table for multiple URLs and their views across a year/month period. The goal is to see...
How to add the timestamp field in Date format in the Date Range Dimension of Looker studio
I am trying to fetch the data from Bigquery to Looker Studio for making a dashboard. Now the issue is that the...
Pivot Table Text Metric
I'm trying to port over some charts from Tableau to Looker. Below is a table I was able to create in Tableau, ...
Bug: CSS code on reference line
Hello all. I'm looking for a solution to remove what looks like CSS code on the reference line. I've not seen ...
Drill down doesn't apply dashboard filter correctly
I have a dashboard with a filter on Month. In addition to looking at events from the last M months, users can ...
Conditional formatting search fields not working
I am trying to do conditional formatting on a text field. However, nothing comes up when I try to search in th...
Time series bar chart displaying counts of two different fields side-by-side.
Hi, I have a Google Sheet that tracks students, and their enrollment and withdrawal date for a school. I want ...
