User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification
This is a two part question - Is there a way to use a parameter field to allow for filtering multiple values? Currently, the filter shows up as a text box that only allows a single value to be input. Am I missing something obvious here? If this isn’t possible, are there commonly used workarounds?...
Hi all! We have a table in Looker that we want to delete. But we want to identify any Looks or Dashboards that might be using this table so that we can implement fixes before we delete it. How do I find the list of Looks/Dashboards that use a table? If I could also find out which fields are used...
I’m having difficulty getting a seemingly simple case statement to work. Getting the following error when running: “-- raw sql results do not include filled-in values” Can anybody tell me why? Here is the code: dimension: product_description { case: { when: { sql: ${product_sku_dimension}=“ab...
Is there a way to update all projects at once? Today, in the develop mode, I have to go to each and every project and update it or synch it but wondering if there is an option to do all at once. FYI - we use our system for supporting our clients and so we have about 30 odd projects to keep up with.
Hey, all. A message I haven’t seen before, ‘Trouble loading data, please try again later”, popped up on one of my tiles. I haven’t seen this message before - the tile loads for every other db I pull from. Any advice?
I have dimension like below, dimension: features_creation_date { type: string sql: ${TABLE}.features_creation_date ;; } I tried to convert this to date using the below function. Its not working. Any help is highly appreciated to have the string converted to date. dimension: features_create_format...
Hi All I am getting the following error in a LookML model on a join - it seems to be trying to join post codes as numeric values, even though both dimensions are defined as sting in the respective views. Any idea why this would be? and how to I get this fixed? we are using a snowflake back-end. I...
Is there any way to add a cascading effect for filters in LookML? I have seen previous posts from a few years ago and the syntax is not working for me. For example if I have filters Car Make and Car Model and I select a Make, then in the Model filter only the car models for the selected car make sho...
I want to add few columns and create a derived ‘total’ column in Looker ( something like total = col1 + col2).I tried doing this through table calculations in the Look and also through a ‘running_total’ type measure in LookML. Both these approaches give me what I want.However, when I need to downloa...
When I get a dashboard from the API and its list of filters, I would like to then make a subsequent call to get the values for those filters. I have not been able to find the correct query to return the appropriate values. When I look in the developer tab for the built in filters, all of the calls a...
I’ve created a basic sql query which means I needed to use developer mode.It’s “committed and pushed” with looker’s git web gui.but nobody else on the team can access it, when I share the link.I was expecting this to be a simple task!
I haven’t been able to find an example of this? The documentation only seems to say it is possible, but doesn’t show any joins to explain it.
Last tested: Mar 31, 2021 There isn’t a native option in the visualization edit panel to toggle value labels on/off for individual series, but please leave feedback for the Looker product team! After authenticating into the feedback portal, you can click here for the open request!Two other options y...
Read about dimension groups in our docs here as well as available timeframes here. When analyzing time-based data, it’s not uncommon to want to be able to think in terms of several different time frames. Say you’re looking at a field like order_created_at and want to be able to think in terms of da...
Is there a way to create a new column based on the values of another column? In another viz tool, I could use the following --- Case [column_name] when ‘Levi’ then ‘Apple’ else [column_name] ENDThey were called calculated columns
I have created a Looker extension in ReactJS application. Able to run React app locally and its working fine with the Looker (added localhost url in the Looker project manifest file). But since the extension running in my local machine it is not accessible to other developers whos working on the sa...
On September 14-15, 2017 Looker held the annual JOIN user conference in San Francisco. One of the sessions was called “Tools for Training Your Team.” This serves to summarize that event! Soon we will be adding a link to a recording of the talk, but you can find slides here already. Why is Trainin...
Last tested: Nov 26, 2020 Faceted (linked) filters in explores aren't possible in Looker. Be sure to give a +1 to the feature requestSituation:Let's say we two have two filters on an explore page: Country and State. We want the State filter to populate based on the Country filter's selection.Steps:A...
Hi there, I have a dimension with values ( let’s say a,b,c,d,e). I have an ask from specific users to present them in very specific ways on the same viz on a pivot: first column would be the aggregate of the first three values (a or b or c should be included in that column or row’s results), then af...
Hello, So my organization has built up a bit of content (Looks and Dashboards) and for the most part we’ve been creating folders for Teams and Departments. I think this works well for reports/dashboards that are primarily used by the given team that a given folder relates to, Customer Service folde...
Hi, We very often track our metrics by Week of year and I’d like to create table where I will be able to compare values with the previous year. But also I’d like to display only last X week numbers of year based on current week number. Let’s say it’s week 4, year 2019 and I want to display only la...
I am trying dimension: tdate { type: date sql: DATE_FORMAT(${TABLE}.“TDATE”,’%m/%d/%Y’) ;; } but not getting output
dimension: value_num { type: number value_format: "0.##" sql:CAST (${value_string} AS FLOAT64) ;; }The result looks like: 25. ← Why “.” ? 3.19 8.3 How can I remove a trailing dot after 25 ?
I am building a report in an explore and I want to know how to make two filters relate to each other. I wan the report filtered by Campaign & Schedule, these two tables relate to each other, if i go to the filter campaign then i want all the campaigns listed (this i can do). However when i then...
Last tested: Nov 20, 2020 The ProblemDashboard-next doesn't currently have description option in the settings panelA SolutionRevert to dashboard legacy, add description in the setting panel and then upgrade to dashboard-next again.You can vote for this feature request on our feedback system. This 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.
