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
We have three data sources which we connect from our PostgreSQL and wrote CUSTOM QUERY to grab data to our dashboard reports. What we’re seeing is every time we open a report, (no matter who or what time in a day) we get a lot of Data Set Configuration Errors. It seems like that we have too many connections, even though there are only three data sources. We are not sure where the redundancy is.Can anyone help us troubleshoot and find a solution?
Hello,I am hoping that our Looker community can help me answer this question.We had set up a SSO embedding with a secret key which worked fine inside an iframe in our application. However, so far this happened twice where we are finding that a secret key no longer works although none of us regenerated it.Does secret key reset when the instance of Looker is upgraded? Or do some other events cause the secret key to be removed?I have reached out to the Looker online support but did not receive any definitive answer.Thanks ahead for your comment.-Tim
@izzy or anyone can you give some suggestion, if there is a simpler way to do it? We have clients, and dates with timestamps… Need to get Max of Date. Sample DataS.NO Client Date 1 AA-BBB-VM9 2022-11-26 15:32:42 2 AA-BBB-VM9 2022-11-29 07:32:50 3 AA-BBB-VM9 2022-11-28 23:32:38 4 AA-BBB-VM9 2022-11-28 15:32:41 5 AA-BBB-VM10 2022-11-28 07:32:37 6 AA-BBB-VM10 2022-11-27 23:32:37 7 AA-BBB-VM10 2022-11-27 15:32:55 8 AA-BBB-VM10 2022-11-27 07:32:41 9 AA-BBB-VM10 2022-11-26 23:32:40 10 AA-BBB-VM10 2022-11-30 13:01:49 11 AA-BBB-VM11 2022-11-26 07:32:42 12 AA-BBB-VM11 2022-11-25 23:32:37 13 AA-BBB-VM11 2022-11-25 15:32:39 14 AA-BBB-VM11 2022-11-25 07:32:39 15 AA-BBB-VM11 2022-12-01 07:04:26
Hello Good Lookers, We have a requirement at my work and could not think of a solution.We are analyzing data on Co2 emissions from factories on a daily/monthly level. We need a visual where we can set the target emissions in the future and the possible path on how to get there. I was thinking around parameters/templated filters to get the target. How do we go about finding the possible ways to get there?
Hello: Looking for thoughts on ways to mass-update user time zones in Looker. I’ve seen other discussions like this onestating that because time zone is a system setting, it is not able to be updated via the API. https://developers.looker.com/api/explorer/4.0/methods/User/update_user?sdk=py&s=update+user shows that it’s not listed as an available option, either. I know that TZs are able to be updated in the UI portal, but if there are thousands of users, it becomes a very time consuming operation to update each one manually.
I have a bar chart with monthly totals (pageviews) and am using a cross filter to show monthly details of other metrics when selected. I have a table including running calculations for each month (month over month percentage changes for each metric). When the month is selected, I want only that month to appear in the table but the table calculations not to change. For example, when July is selected I want to the table to display the percentage changes compared to the previous month (june) instead of compared to itself (as that is the only data not filtered out).
Hi!I’m creating the LookML Dashboard - with a table and some filters. I’ve implemented column-level access restrictions, using user attributes and access grants on dimensions. So, some of the columns on the Dashboard, containing sensitive data, are visible only for the users who are added to the specific group. My problem is, that there are also filters added on those columns - and those filters are always visible on the dashboard, even if the user can’t see the columns in the table. Is there a way to hide only those filters? Or maybe disable/colour/mark in any way? I haven’t seen such an option for filters, but maybe there is some workaround.. Or the only way to have different filters for different users is to create separate Dashboards (which I would really prefer to avoid)?
Hello Experts, Customer has configured private instance of looker and while logging in for the first time, they are coming up with the below screen. Any pointers, what could be missing?
Hello, Can I set how a dimension is shown in explore? For example for a dimension "Product_name_n”, can I make this as “Product name” in the explore?Also, dimensions auto-convert "_” to space, what if i need an "_” in the name in the explore?
Hello! I have data regarding scores in four different tests (A,B,C,D) & I would like to be able to track the distributions of these scores (scale 0-100) per test. I know that creating bins per test scores is an option, but is there a way I can create a custom bin table or bin dimension and use it for all tests like shown in the print screen below (image taken from looker and customized to meet this project’s requirements) ? (Basically create the bins below [0,20),…,[80,100] to use for all test scores)
Looker will not be updating this content, nor guarantees that everything is up-to-date. IntroductionMost SQL dialects don't support robust table-generating functions. There are a few common use cases for table-generating functions, such as creating a sequence of numbers or dates, un-nesting a JSON object or array into rows, or splitting a string on a delimiter into rows.In this article, we'll show an example for the last use case: Taking a string containing n distinct comma-separated values and splitting it into n unique rows.SetupSuppose we have a table of products containing id, name, and tags: productsid name tags 123 Scrunch Cloth Pants Set Pants, Throwback, 80s 1287 Le Suit Citrus Breeze Skirt Suit Skirts, Dresses, Business Casual 486 MaxStudio Plaid Romper Jumpsuits, Casual, Rompers Our goal is to un-nest the tags to create a table to map products to tags. We will assume that a table of numbers already exists in the database, though this can be created using t
Last tested: Sep 7, 2019 Say you want to filter a column by multiple values in a "sub column", i.e you have a column order id's and a column product id's, and you want to filter for order id's that contain product id A AND product id B.The issue: You can't use a custom filter because that filter is a row based filter and won't account for multiple row values of product id for one value of order id.The bad solution: You can use a PDT to filter on product id A then filter on product id B in the explore (or in a derived table with the filter for A as a sub select)The better solution: A group concatenation aggregate function! How this works: The aggregate function works like any other function and will concat values based on the grouping. Implementation: We can either useApproach 1: Create measure type listmeasure: product_id_list { type: list list_field: product_id;;} Approach 2: Create measure of type string and use appropriate sql dialect for group_concatmeasure: group_concat_product_
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.
