How to hide null values for merged result
Plot Null Values' doesn't exist for merged result. How can I only show values that are not null on merged resu...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Custom field data not matching data using custom filter.
I've created a custom field to bucket site sections using a case statement based on page path. However - this ...
Table calculations of totals and row totals?
Question: In past I know that table calculations weren’t allowed for totals. See [RETIRED]Why don't my table c...
Is it possible to run a look as a specific user?
Can you make a specific look or a dashboard run as a specific user? For example, it's a look showing broken qu...
Simple solution for period-over-period reporting and pacing in Looker
Hi all, I wanted to share a simple solution for period-over-period and pacing reporting.Period-Over-Period1. S...
How can I use linked filters with dates in the dashboard?
For a use-case such as, I want to: Choose the start of a week in one filter and then choose the days of that w...
Drop Down Control Defaulting to NaN
Hi all,When trying to select any value or combination of values from a certain drop down control filter it aut...
Custom Visualization
I am trying to create custom visualization in looker. It is giving me error “no identifier should be given for...
Displaying duplicate values
I'm able to display duplicate values by adding a count measure that's tied to my field hash id. I then added a...
Monetizing Looker Studio Dashboard
Hi, I have created a model dashboard and was wondering if I am able to monetize them by putting it up online f...
Group based on AND condition
Hello all. First of all, love the new GROUP feature in Looker. Super helpful. I have a question about it thoug...
Calculated Field with IF statements
I am trying to create a calculated filed based on an if statement to categorize and add the sales in Looker. I...
Custom Brand Logo/Image recommended Dimensions
Is there any specific dimension( aspect ratio, specifications, size dimensions in pixels) for Logos/images whi...
Red/Green Conditional Arrows
Hello Looker Community, I am building out a single value visual that is meant to to show the percent change of...
How to add an exclude drop down filter
I've been using Looker for a while now and have been stuck on trying to add an exclude filter so that a certai...
LookML Dinamic Filters
Hey, I want to filter my report with a dinamic date, shifting between 21st previous month and today. How I can...
Use Custom Dimension as filter on Dashboard
Hi folks,Basically, I want to know if that’s possible to create a custom dimension or custom measure on a visu...
Custom field not populating after creation date
I'm building a dashboard using the Google Search Console API connector, and created two custom dimensions: one...
Cross filtering on dimension and metric on whole report
Hi everyone, I have the following table where I get every week in two free text fields a color and the reasoni...
Summary Row Table Is Null
The Summary Row Table Is Null, see attached an image. I use a filter for replacing things. > Can somebody help...
How to hide a column based on access_filter
how to hide a column based on access_filter.Assume we have a multi-tenant look and we are using the unit id fo...
Is this the best practice for having totals and averages available on the same measure?
Is this the proper way to do this? How do you guys handle the option for users to select either the average/mi...
Is there a way to directly upload data from an Excel file or CSV into Looker?
I serve as a Looker explorer at my company, where I endeavor to upload the data, independent of the warehouse ...
Schedule Looker Reports to G-Chat Space using Google Apps Script.
In our busy lives, finding ways to simplify and automate tasks is crucial for productivity. Thankfully, Google...
diagonal x axis values fail when there is no left y axis
here is the graph with two y axes but when user swithes off the serie which has left y axisthen x axis fails t...
Series in Looker
How to create a constantly increasing column in Looker?Eg:10000, 20000, 30000, 40000, 50000, ....................
Get average of data where 2 pivot column match
Hi EveryoneI have a looker look which uses 2 pivot dimensions. You can see below. One is Degree term ID, secon...
Looker expression editor _ subtraction by pivot rows (sum by grouped dimensions, then subtract)
Hi,I am new to Looker, not sure if it is possible using Looker expression editor to achieve this (I cannot use...
Filter positioning on specific tiles
Is it possible in looker to place filters on each tiles and show filter near to specific tile in dashboards, I...
Bar chart of Percent difference in the positive and negative direction
Hello everyone,I'm hoping to get some help making a bar chart to display percent differences in both the posit...
