User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification
Update: This article is now out of date. For the latest info on how to download or generate client SDKs for the Looker API, please see our Looker SDK Codegen repo on Github The Looker API is a collection of “RESTful” operations that enables you to tap into the power of the Looker data platform in...
As of version 3.28, you can now plot measure vs. measure scatterplots. This can be done by hiding the dimension(s) in the data table from the visualization. For example, say you have this data table: In order to chart Orders Count vs. Order Items Total Sale Price, you will want to hide Users Age f...
Date Comparison Block What is this block? This block allows for comparisons from one date period to another, or from one date period to a number of periods. It provides extensive flexibility in comparing date ranges, and presenting these back as a single visualisation. The code can be found in this...
You will likely want to unsubscribe from this topic, unless you want to get a lot of emails! While we work on a better solution, make sure that after you post, you toggle the Subscribe button off, as it will automatically turn on after you post in the thread. You want the star to be white/empty (lik...
Some users have wanted greater control over how fields are grouped in Looker’s field picker. Looker 3.44 adds the new group_label parameter to let you group fields together, even within the same view. Existing Things You Could Already Do Since 3.20 it’s been possible to adjust the first level of gro...
Is there a way to let users update data on DB right from looks? I read about actions here but I found it very abstract. Can someone please explain the process for this? Thanks, Krish.
The content of this article has been updated and migrated to a Looker Help Center article. But, the information in the comments is useful, so the article will remain here for discussion. For the actual contents, please visit the Help Center.
Hi there, I am trying to create a simple python script to copy dashboards (these are user-defined dashboards), as well as their underlying Looks. Basically I am reading the info from the “source” dashboard, and using the create_dashboard and/or update_dashboard API calls. I am being stumped by a...
Beginning with Looker 4.8, we introduced a new model level parameter called fiscal_month_offset:. This will allow you to define when your fiscal year begins for each model if you don’t use the calendar year for your quarters. To set your fiscal year, navigate to your model file and include this para...
there’s multiple data types available in snowflake - Timestamp_tz, timestamp_ntz.when we use dimension group function in lookML (time type), and I bring out a filter using dimension group field, for example, we want data after 2020.01.01, LOOKER will generate TIMESTAMP_TZ in the query rather than ti...
The content of this post has been migrated to a Looker Help Center Article. The comments will remain here, as there’s useful information contained within them.
I changed my column chart to bar chart, in order to test what would be easier for people to read and noticed that if I do that, the label of the most negative field goes outside of the viewport.
Can I set colors (or apply other custom formatting) in my bar chart based on a measure’s value? Here is a simple example generated in Excel. There is a red reference line at 130. All the measure values greater than it are dark green and the bars below it are a lighter green. I like how I can use th...
Is it possible to create a tabbed dashboard? This would essentially combine two or more dashboards within a single dashboard, viewable by selecting the tabbed navigation.
Consider the following Bigquery View: SELECT CURRENT_DATETIME as dt It produces a single column of type datetime Then use “create view from table” to produce the view code: It produces the following code: view: test_datetime { sql_table_name: views.test_datetime ;; dimension_group: dt {...
As of Looker 3.30, it is possible to perform date operations in table calculations. This includes subtracting dates, extracting dateparts from dates, creating an absolute date, and returning the current date. Subtracting dates Dates can be subtracting by using of the functions starting with diff_. Y...
Something that comes up occasionally is a request to add a custom map_layer to Looker that is very large. Most commonly the questions start when a user realizes that the TopoJSON file for their custom map is hundreds of MB or even GBs and that loading the whole thing into the browser at once isn’t g...
Hi, We’re doing some administration of Looker on BigQuery. Is there a way to associate a Looker query with a BigQuery Job ID? We’d like to be able to get detailed BigQuery job stats and execution plan for specific Looker queries that have run.
Hi all! I was playing with the new Explore field picker since our instance has been upgraded last night and I had to deactivate the feature almost immediately due to some very annoying issues: Using the search feature, I did a DATE search and the new explore field picker was showing like 15 date...
The Problem As a Looker model grows in size and sophistication, it will also experience an ever-increasing number of Explores, Views and Fields. Unfortunately, a common side effect of this is model bloat, which typically means a less than great end-user experience. The Why Henry is a command line to...
Say I have a list with six flags, true or false. Each row can have true/false in six different metrics. My dashboard is showing six columns (one per metric) and the counts for each row in the list where that specific flag is true. What I want to do is to click one number on any metric and return t...
Hi, I’ve just started using Looker and I created a histogram of two data series that are blended together. So I have 2 dimensions, “grouping” and “monetization”, and 1 measure, “percentage”. So a sample of the data would look like this: Grouping Monetization Percentage A $1.00...
Hi, I am looking to add a filter on date: Idea is to get real time orders from order table (local time is EST) My column is a date column in EST time zone whereas looker is in UTC. Is it possible to convert looker default time zone to EST since I want in EST
Hi all. I’ve created a relatively simple look for a client. It has more than 70 columns: 4 measures, 16 table calculations, and 50-odd dimensions. The thing is, the columns have to be displayed in a specific order. And that order has the 16 table calculations shown first, and the 4 measures randomly...
Short question: Will Looker support BigQuery BI Engine? Info here: Google Cloud BigQuery BI Engine documentation | BI Engine | ... A fast, in-memory analysis service that allows you to analyze data stored in BigQuery.
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.
