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...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
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?
How to Sort by one Dimension and one Measure in Bar chart
I am new to looker, We have a bar chart with Sales on Y axis and Date on X axis, We are looking for sorting op...
Convert Custom Dimensionon field from string to Number #UiPath Insights #GoogleLooker
Hi all, i’m new on the community and I’ m a newcomer to Looker technology. I am trying to add a new Custom Dim...
Merged query - Column limitation
Hello everyone,I merged results from two different explorers - each presents some data (for the context - numb...
Scatterplot with two dimensions as axes and a third as the value label
I am unable to access the data of more than two columns on a scatterplot in order to use the third as a label....
Filter if value exists and display multiple values
I’m not too sure how to phrase this but I have a field I want to return all values for if it contains a certai...
Measure filters don't apply to totals
I have a Look similar to this one:Customer (dimension) % of good reviews (measure) % orders reviewed (measure)...
