User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification
New user? Click here to get started in the Community.
Learn about our awesome events
Ask away! Someone here has an answer.
Find others interested in the same topics as you.
Get the latest news about Looker & the Community
A collection of Looker knowledge for you to explore
Has anyone else had issues with HTML rendering differently in the new dashboard experience? The spacing looks totally different from how it appears in our legacy dashboards. The example below shows the exact same tile in legacy vs new for version 21.6.39. The divs and line breaks get so much additio...
Hi,I am using Snowflake in Looker. I have a Items column which has multiple JSON objects inside an array. I need to extract only the information in 'quantity' json field i.e., i need to extract the quantity number 1 from both the quantity and return as their sum 2 in dimension ”total quantity”. Plea...
Last tested: May 6, 2020 Is it a pivoted query? If so, it could be a case of “When the clock strikes midnight the visualizations come alive with a mind of their own.”The series editor is based around the pivot value of the series, so any visualization settings you have set on the pivoted series (col...
Hello, I am trying to get a bar graph(s) in which there are four categories that represent different bars, the measures are pivoted creating separate colors for the stack in the bar. Then also have each of these groups over a week, one group for each day. Something along the lines like this. But ha...
Is it possible to filter by table calculations? I have a simple calculation at the end of my row that shows the highest value in the row (hundreds of data points). Now I want to filter on that calculation and only show rows with values above a certain threshold. How would I accomplish that? One n...
Good day all,Been trying to find a way to add a year criteria to the first ‘if’ statement as per :if week < 40AND year = 2021if(${flxt_shipment_carrier_booking_ocean.first_port_latest_sched_departure_week_of_year} < 40 OR position(${flxt_shipment_carrier_booking_ocean.carrier_booking_vessel_n...
Hi! How could I remove the table name from the legend? I’m using a line chart to show the trends over time and I’m grouping the total costs by type (“Hourly salary” for example) and cost type (“Total Absencecost” for example), but the table name “Poc cost” appears in the legend and I’m not able to r...
Hey there!We have an application, where we use an iframe to embed the Looker dashboard. Faced a challenge to authenticate a user through my application but with Looker account.So I need to authenticate user through my app but with their Looker account.In Looker there 3 variants of authentication, as...
I need to store resulted data in csv file with scheduling and that csv file need to be encrypted before scheduling to the Google cloud storage bucket. is this possible in the Looker ?if yes what all the steps i need to follow please help out on this POC part.
I know it’s old school, but interested in comments from those who have built an RFM model. Since we have mysql, we couldn’t use windows functions for the quartiles, but the core logic was easy with case statements. User Detail: Code Snippet:
Is there a way to do a percent of a subtotal in a table calculation or LookML?
I want to create a query that tracks when my management gets errors running dashboards. I see that errors connecting to database can be seen in history.message and SQL errors can be seen in history.status. But I don’t see any way to see when queries got the error “row limit reached” - this is not se...
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
