LEFT JOIN issue with SQL_WHERE clause
I have an issue with displaying JOINED tables together. This is what I have: And this is what I would like to ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Create custom groups based on user_id without adding new dimension
Let’s say I have a list of user_ids = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] group_a = [0, 2, 7, 8, 4] group_b = [1, 3...
Concatenate a measure and a table calculation as custom field
I am a complete newbie to Looker (I have been using it for less than week so kindly pardon my ignorance) . I a...
Performance Audit 2 - two tooltips clash
Looking at performance audit dashboards and noticed that if columns do not have enough space to show the label...
Standard Deviation and Simple Time Series Outlier Detection Using Table Calculations
I recently used this technique as a quick and dirty way to find anomalies in time series data and thought I wo...
Weekly Average by Monthly Average Ratio
Hi Guys, I am new to Looker and have come across a requirement, where I need to display the weekly average use...
Limit Displayed Rows vs Query Row Limit?
Hi All Is there a performance difference between limiting your visualisation to say, 18 rows, vs. limiting the...
Printing Looker Dashboards as single column PDFs to include page breaks between dashboard elements
When printing Looker dashboards be sure to download or schedule the dashboard PDF with the single column PDF f...
two Sankey visualizations
In Looker 7 we now have access to /marketplace which has a Sankey visualization. We also have access to a Sank...
Schedule Dashboard With Conditions
Hi, I’m trying to replicate the functionality of scheduling look deliveries only when there are results but fo...
Hover note not accessible (overlaps query last run date)
It seems when the width size of a tile is fairly small, the hover note is not accessible. Instead, the user se...
schedule a look (menu item missing)
I’m trying to schedule a Look following the instructions here: Looker Documentation Scheduling Data Deliveries...
Multiple visualization in a look with each showing a single metric/column...possible?
Hello, Let’s say I have a simple look in a pivot table that is showing a number of products bought each month ...
Dashboard Next broken conditional formatting
My Single value viz in Dashboard-Next are broken with conditional formatting. 2 issues: The main value font is...
Dimension to categorize row based on shared ID
Hi Everyone, I apologize if there is a solution to this elsewhere in the forums, every thread I found seemed t...
"After Today" filter returns results from the previous day
I’m using a custom filter of simply “After Today”, but am seeing results from the previous day. Am I missing s...
How to Teach Looker - Intro to Looker, Using the Explore Interface, and Sharing Content
This article is written with the Looker implementation leader for your company in mind. However, it might be a...
Date Range Filter with Relative Dates
Hi there, Looking for a way to create a date range filter that has relative start and end points (i.e., create...
Running Total with Pivot
Currently, I have a running total going for each fiscal quarter, but what I’m looking for is the running total...
Rolling average using offset_list in table calculations (3.36+)
As of Looker 3.36, we have introduced a offset_list function. This function allows you to create a list from a...
Automatic filter for 'this month' on dashboard
I have a user-defined dashboard which normally shows data up to the last complete month. I’ve set its default ...
Downloaded data file contains: Error: Could not sort by calculated field 'total_bla'. Limit reached
Hi, I’m trying to download data for a dashboard and am getting an empty file containing: Error: Could not sort...
Exclude Table Calculations For Null Columns
Created a calculated column for WoW comparisons. Is there a way to exclude instances where all values are null...
Whitespace in Looker
What is whitespace? Whitespace is a character that will occupy space on a page but does not correspond to a vi...
Localizing View and Field Names in Looker
In LookML, you can use aliasing parameters to make data exploration in Looker a much more user-friendly experi...
Date filter up to current point in time
One of the first things I do when I use new BI tool is to come up with sets of dashboards that compare the fol...
Comparing Different Rows Using Table Calcs
Hello fellow Lookers, I spoke with a customer the other day who wanted to compare where their web traffic was ...
Using Merged Results to Do Period Comparisons
Comparing results between time periods can often seem daunting at first glance. Many people fall down the rabb...
Secondary axis creation?
Hi all, I found a very old thread on secondary axis creation but the directions no longer apply or work. I wou...
Prevent Multiple Results in rows
I have a dataset in which I need to calculate the monthly average using the daily counts. So I need to include...
