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
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?
I am currently trying to display Months in a word format instead of a number format for a tile. Above is what it looks like right now and I want it to say JAN-DEC instead.This is what the table calculation is:This is what the entire tile looks like data wise: Below is the Reporting Date Month custom dimension”
Hi, I have one query that creates some results with two pivots (count of sessions) and then I create simple table calculation based on both of those values. I have another query, which is similar just in a different vertical. While using Merge pre-existing looks by using unique URL of look this I created the URL but I’m getting this error: I’m actually not using the data from the pivots (I have them as Hide from visualisation) but just the table calculations. If I still add the join I’m getting something like this: I understand that there is a Calculations button in the Merged Query window but was wondering whether support for having those table calculations in the existing looks will be added. Moreover the biggest problem is that I need the pivots. Is there any way to be able to merge queries/looks with pivots?
Hi, I wanted to know why the location of filters on Looker dashboards are fixed. The filters are stuck at the top of the dashboards.Though , this renders a neat outlay to the entire dashboard …. it sometimes confuses the audience/presenter when we have multiple filters applicable to multiple tiles.For eg. If I have School Name as a filter...and it is applicable to 1st 2 tiles of a dashboard, and Student Rank as another filter applicable to last 2 tiles…. the relation between filter and related tile would be clear if the filters could be located next to concerned tiles instead of a common location at the top of the dashboard.I was curious to know why Looker chose to house all filters on the top…. and if users could be given flexibility of moving these filters near related tiles…. Thanks!
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.