Highlight values in rows using Formatting
I have a pivot table with main dimension and dates.I'm trying to find a way how to highlight smallest/biggest ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Looker Single Day Filter (Set to Yesterday)
We want to have a SINGLE DAY FILTER (aka not allow anyone to choose multiple days / ranges) but have it defaul...
Dashboard - save multiple filter values and auto-apply them in Look
My caseI have a dashboard with Filter panel. One filter can have multiple values. I want to save the selected ...
Dynamic Dashboard Filter Help
Hi all,I am trying to figure out how to create some sort of dynamic filter for a dashboard I am creating. The ...
Potential bug - Total Labels on Stacked Area Chart
Column chart seems fine but the Total labels for stacked area chart seem to clash with the top-most series:Has...
Looker Date Filters only being displayed in development mode
I have a dashboard which was built a few months ago, and there have been no changes made either in the backend...
Row Totals in Visualisation - Gear icon doesn't work in tile editing modal
The latest Release gives us ability to show Row Totals in the visualisation and to hide it or any pivot.Howeve...
Dashboard Drill downs
hi!While using the dashboard drill down feature, is there a way we can restrict the dashboards being pulled fr...
How to hide measure with 0 in Bar Chart?
I have a bar chart without any dimensions and a bunch of measure. I wanted a way to hide the measures which ha...
Hierarchical Table/Matrix with Subtotal and Grand Total
Hello Learners and Experts,I am new to Looker and exploring looker’s different feature. I wanted to create Hie...
Dashboard Scheduling Error
I received an email saying the delivery has failed while I actually received the delivery.In the example I was...
Filtering using 'and' 'or'
Hello!I’m quite new to looker and need a quick help creating a filter so it can accommodate ‘AND’ and ‘OR’.I w...
Monospaced font
Even though Roboto is not a monospaced font, at least the digits were monospaced and it made looking at dates ...
Data Set Configuration Error
We have three data sources which we connect from our PostgreSQL and wrote CUSTOM QUERY to grab data to our das...
Create buckets to pivot by
Hello! I have data regarding scores in four different tests (A,B,C,D) & I would like to be able to track the d...
Need the count if there are values in 2 columns
If both column A and column B has value, I need the count.
Summing values of a dimension based on criteria of another dimension
Hi all,I have been stuck on this for longer than I would like. I have a table with various dimensions. One dim...
How to default date filter to maximum date in dataset?
For context, we have a campaign that sends an email out once a month. On the dashboard I created to analyse th...
Copying a single line, but the column total also pastes
When I highlight and copy a single row of data in a table visualization, and then paste that data outside of L...
How do I count only non- null values in a row in table calculation
I have a row of data with some null values, I just want to count the times that the value is not null. Is ther...
Filter impact is different at dashboard and in tiles
In my dashboard which contains metrics using multiple explores. It is having two date filters. I have made the...
System error issue with Google Cloud SQL text column
Hi! I have a text column coming from Google Cloud SQL that causes a system error whenever I try to pull it in ...
Find records in one table which are missing in another table
How do I find records in one table which are missing in another table; like a minus in sqlselect id from table...
same time previous days
How would I compare amount of orders closed at the current time to orders closed in previous days at the same ...
How to display grouped values as a percentage of that group?
Hello!Here I have the number of orders grouped by market where each column represents the number of days it to...
Mandatory Filter
Hi, I want to use column Country as a filter for the Dashboard like this: every time a user opens the dashboar...
Using pivot_index in table calculations (3.28+)
Introduction As of Looker 3.28, we may use the pivot_index function to compute a single calculation across the...
GSP346: Exploring Data with Looker: Challenge Lab
Hello, Has anyone been able to obtain a green progress check at the first check point “Click Check my progress...
Link Individual Tables
I would like to create a link to each of the tables in my page. Is this possible?
