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
I’ve been searching around and can’t find an answer. Hoping to get some help here. I am trying to create a dynamic precent total table calculation where the denominator stays the same but the numerator can be changed with filters in a dashboard. For example. I want my stakeholders to be able to understand how much of revenue comes from one customer in a state of all revenue made. lets say we have $100,000 in total revenue and I want to know how much of customer A in Texas. A sample table is below to make more sense.State Customer Revenue TX A $50K CA A $10K TX B $20K NY B $20K With the scenario above I want them to be able to filter a dashboard to see the followingState Customer Customer Revenue Total Revenue % of Total Revenue TX A $50K $100K 50% Basically I’m struggling with the “Total Revenue” being ignored by other filters. Ideally I would like the filter that can effect the “Total Revenue” is a date range. Any help would be greatl
I wanted to request the ability to collapse tiles or sections in the dashboards. If these could flow through to how the PDF displays that would be great.
少し気になることとして、並び替えが2つまでしか設定できない。ソートするフィールドを新たに追加しても、SQLのORDER BYが使えない。何かいい方法はありますか?
Hi - I have been tasked with deleting a bunch of users’ accounts and I would like to back up their content, bookmarks, favorites etcWhat is the best way to do this? Also can it be done using the API?Thanks
I have a line chart with a count of months on the x-axis and a cumulative count custom measure of some metric on the y-axis. There are a number of lines on the chart as a result of a pivot, each one representing a person. I’d like to add a line representing the average of all the other lines, that is dynamic - i.e. if the chart is filtered, the average will change. Is it possible to do this?
Hi all, I am pretty confident in Looker, but I wanted to see if there is a better way of doing this. When I have a bar chart that is pivoting on another dimension, I almost always need the stacks to be ordered descending, however, the default behaviour in Looker is to sort based on the values within that particular date. This means that the stacked elements jump around a lot and makes it hard to see consistent change. So my only options are either to have default sort and the stacks are not organised by volume at all:Or to have them stacked by volume and then the stacks can look chaotic:I know that there is a “hackaround” using derived ranking tables, but doing this for every chart and every view is a pain in the butt. I really feel like this is relatively simple and should be a chart setting, not something that requires building and joining yet another view (too many solutions to simple problems require a new view, which overcomplicates models, in my humble opinion, so I would like to
I’m doing a left outer join and sure some are not going to be 100% match, hints the left outer, but how do you..or where would you write an if statement to say ‘if null then foo else bar’ in the explore after you do a left outer join?
In looker charts . Just like we have an option to open a drill down menu . Do we have an option to close a drill down menuLookerCharts.Utils.openDrillMenu({ links: cell.links, event: event }); As of now when we click outside the custom visualization the drill down will disappear. How that is happening and is there any way a custom viz can call that function to remove the drill down from chart
I have a field, “referring_domain” with 10k values. I’m using suggest_explore to populate suggestions from a small table in bigquery, with a cache of 72 hours. Ideally, if a user types “facebook” into the report filter, all of the possible values containing “facebook” would show up to ensure they are able to select their desired domains. I’m encountering an issue, however, where the suggestions include “facebook.com” but not “fb.facebook.com”. I’m wondering if this is being caused by the Limit 500 being applied to suggestion queries. If so, is there a way to bypass this limit? Or is the filter being applied as “facebook%” instead of “%facebook%”?
I have a requirement where I want to freeze the headers of my table (report) visualization ,as after a certain amount of data scroll I can’t see the headers and just able to see the data . I didn’t found any option to achieve that , Please let me know if there is any way to resolve this.
Good performance is a key component to providing a good user experience, so we are continuously investing in improvements to the end-to-end performance of Looker. The latest enhancement that we’ve made in this area is the development of a completely new LookML compiler, now generally available across all Looker instances. What does the LookML compiler do?Looker’s LookML compiler, also called New Looker Runtime, is a core component of the Looker application. It is the backend engine that validates your LookML and translates your LookML into SQL queries when users are exploring data or working in dashboards. Specifically, the LookML compiler is responsible for the following: Compiling a model: Parsing and loading a model into cache, which occurs every seven days or after any changes have been made. Validation: Parsing LookML code and front-end content and identifying any errors. Generating metadata for an Explore: Identifying and exposing views, fields, and other metadata from the Lo
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.