datastudio function ranking or herarchize
Dear friends, I need your help to generate a kpi. Exactly I need to hierarchize, and to know what position occ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Using Liquid in SQL parameter to refer filter values
This section mentions that Liquid can be used to calculate a measure using filter values as the input. But whe...
Creating Comparison for Single Value to Compare last 7 days to the previous period
I’d like to create a tile that compares a single values last 7 days dat with the previous period - and then sh...
Dashboard, set last date as default in date filter?
Hi everyone,I have built a dashboard with a month filter (date time format).The info in this dashboard read fr...
Export/import user-defined dashboards
Hi everyone,The project i was working in got deprioritized. That work includes a explore in a development bran...
Custom dimensions based of same date format from multiple dimensions
I want to have a custom dimension that allows me to merge two dimensions in an explore that are both from diff...
Fx MIN GROUP BY unable to spot the expression error
Good day everybody!I'm a newbie in Looker. Currently i have created a simple Look with 3 columns.Columns A: Ve...
How to build a closed funnel graph?
I have data from Google Analytics in my Bigquery project which is linked to Looker. I was trying to figure out...
Date filter with default settings= automatic date + yesterday
Hey, I'd like my date filter to look like automatic date but with yesterday's date filtered as default. The th...
Creating closed funnel in Looker Studio
I have created custom events, to be passed onto the dimension "Event name" during the user journey on my websi...
Creating/modifying theme for table (report) object
Hi everyone,I'd like to change the appearance of the object table (report) to match our corporate colors.I've ...
Expand table results
Is it possible to create a table in a Looker dashboard that shows the top 5 results by default, but allows the...
Scheduling custom looker PDF reports to hundreds of users at once
Hi,By using the schedule option in the dashboard, can I schedule 100s of reports customized to each user based...
How do I format hh mm ss in looker studio ?
So I connected my google sheet to looker studio and the goal is to find the average ride length of rides for b...
Numeric (Numbers) format not working
I have a .csv file, exported from a data provider that helps us track sales figures across our industry. When ...
Looker table look value label position
Hi i'm pretty new to looker. How do i place the value labels on the pink bars (instead of next to them) in thi...
Calculating percentages
H! I have a table with answers coming from a multiple choice question. The counts are OK, but the percentages ...
Add A Filter For Pivoted "Percent of Row" Calculation
I am trying to create a filter so that my dashboard users have the ability to filter out servers with a low sa...
How to caluculate budget
I want to retrieve Facebook Ads budgets from my text string. When I extract them, they are duplicated by date,...
Grouping in costume dimensions
Hi,I created a costume dimension that counts days since activation to current date and called it days_diff. Ba...
How to remove Table name prefix from table chart in LSP
I am getting table name prefix for every column in looker studio pro while creating table chart. also, its app...
Quick Start capabilities
When building a Quick Start for an explore, the default settings are extremely limited. You can apply filter, ...
filter on latest date from the table
I want to apply latest date filter in where clause of my explore but its not working. I tried using below code...
Merge query - sql extract
Is there a way to extract merge query at the backend. What actually looker does behind the scenes to do a merg...
Padding, RPAD or LPAD in Looker Explore
There is a need for us to generate fixed length fields from a Looker dashboard. Is there anyway I can RPAD or ...
Creating a form for user input in Looker.
Hi, I have a requirement in which I want to show a form onto the looker dashboard. This form would show 3 fiel...
Filtering between different explores
Hello,I'm trying to add a filter to a dashboard that sources data from 3 different explores/views. I need to s...
Drop down list not showing in asc or desc order
Hi, I have an issue with one chart in a report. The Drop down list filter doesn´t show the values in order bas...
Filter Enhancements when using Looker Connector in Studio.
Hello All, Looker Studio is introducing the following filter enhancements to improve user experience with Look...
Time series with irregular dates seems to be summing up certain values
Hi! I'm charting open rate over time for emails. All of my open rates are below 0.75 (i.e. 75%), but when I ch...
