Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
New user? Click here to get started in the Community.
Learn about our awesome events
Level up your knowledge with Looker's training hub
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
If I have a datagroup with a sql_trigger of ‘SELECT CURRENT_TIMESTAMP" (that is, it selects thecurrent date, hour, minute, and second), then how often will the cache be cleared by this datagroup?
We need to filter a look by a specific account number pattern: it starts with the letter H and then is following by a number (0-9). There are lots of account numbers that start with H, two additional letters, then numbers. In PostgreSQL, I can easily do it by doing … WHERE account_number ~ E'^[h]{1}[0-9]+' I cannot find a way to do such a thing in the advanced filter in Looker. Currently, I’m simply doing… account_number starts with H1 H2 H3 H4 H5 H6 H7 H8 H9 H0 Is there a more elegant solution? I need to do this again for an additional scenario where it starts with any letter then either 2 or 3 numbers. (In PostgreSQL, it’s E'^[aA-zZ]{2,3}[0-9]+')
I have a dimension column for each month in the year (2022-01, etc.) and two other other columns, one being a dimension of the product name and the other is a measure of the sales. Is there a way to limit the number of month occurrences to just 10? So basically having the top 10 products for each month in a single table.
In LookML I want the label to change based off of the year that is being explored. For example, the measure is focusing on a calculation from data that comes from 2 years ago. The year is currently 2022 so the label would dynamically change to 2020 since we are looking at data from 2 years ago. What tools would I use to make this happen?Thanks!
HelloJust as an FYI, I cannot use LookML. I am forced to stick with custom filters/dimensions/measures/table calculations using table variables (ie ${customer.name}). Please do not post LookML code as I am not allowed/have access rights to LookML since it will affect all the reports that the entire company makes.That being said, here is the issue. I have a table that table that looks like this, where a customer can use 2 different products simultaneouslyCustomer Primary Secondary A prod1 prod2 B prod3 prod1 C prod3 prod2 D prod2 prod3 E prod4 I would like to create a Look that will group the list of Products (i.e. Prod1, Prod2, Prod3, Prod4) and count how many customers use said product as their primary or secondary use. Ideally the results would look like this The 2nd table shows the number of customers that uses each product as their primary or secondary. My problem is how do i get a count of customers who use the product as their secondary? It always
Hi!I’m not able to set the colors of Up, down and total bars on a Waterfall chart.There’s nothing to click, and there is no advanced series option.The plot is built upon 1 dimension and 1 measure.
Hello, Is it possible to add a single value visualization on top of an existing chart, for example a column chart, in the same look? Here is the end result I am looking for:
Hi, I’m looking to build a dashboard showing the turnover of our firm. Usually people in our firm will query turnover from a given month or from a given day. In order to optimize performance we created a table in big query that is partitioned by days. But when we show month it still takes some time to show the figures. So we wanted to created another table that is basically the same query but pre-aggregating by month. And then we partition by month. How can I build a parameter that allows me in a dashboard : 1/ when i’m choosing day granularity, look for the view partitioned by day2/ when i’m choosing month granularity, look for the view partitioned by month
Developing in project on release 22.8.32 with Legacy LookML enabled (Aragonite setting). When team member switched setting to default (Aragonite enabled), developers in project were no longer able to validate LookML, getting error below. Errors out of date. Click the test button to validate your most recently saved LookML.Changing setting back to non-default/Legacy enabled. Error went away. Concerned about what will happen when the ability to enable Legacy is deprecated in future release.Any guidance?
I am trying to embed a dashboard in Coda. The dashboard I have embedded requires that the user authenticate in Looker. Once I authenticate the dashboard just displays as a blank page with no visualizations. Is there a way to remove the authentication requirement? Why would the dashboard not display properly when embeded?
Last tested: May 31, 2019 All file names look like scheduleName_timestamp_hash, where hash is a random 6-character identifier and the timestamp follows the pattern YYYY-MM-DDTHHMM (e.g. 2019-05-31T0933).There is a feature request ticket to be able to customize the file name of files sent via schedules: Change file name for data sent in schedules This content is subject to limited support.
Google acquired Looker in 2020. Since then, Looker customers who also use other Google Cloud products have received support for Google Cloud products and services in one platform, and support for Looker in a different platform. We're now moving into a new phase of the acquisition, where customers who have Looker and are an existing customer of Google Cloud with Standard Support or Enhanced Support will receive a fully integrated support experience. This phase of integration will deliver a streamlined service whereby all your queries for both Looker and Google Cloud products can be submitted through the same platform. Therefore, from August 1, 2022, you are able to submit your Looker cases from the Google Cloud Console. Customer Care delivers a secure, powerful and flexible support platform where you can choose the service that is right for you. Whether that’s a fast response, a self-management service or an additional service to enrich your experience, you’re in control! The three co
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.
