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
This would be the logic: e.g.:Casewhen CONTAINS_TEXT(Country drop down,"us") then ((Clicks*0.015*2000)-Cost)when CONTAINS_TEXT(Country drop down,"uk") then ((Clicks*0.018*1500)-Cost)ELSE ((Clicks*0.012*1000)-Cost)END So far I have been getting an error that dimensions can not be combined with metrics in formulas. Thanks a million for your help.
Hi, I would like to add a user name that will be reflected in the dashboard. The idea each user that will use the dashboard will see the following: " Hi ‘user name’ ,welcome to my dashboard" I have tried the below code in lookml: dimension: attribute_test { type: string sql: {{ _user_attributes.[‘name’] }} ;; # html: {{ _user_attributes.[‘name’] }} ;; } Tried with sql or html ,with no success. What i’m missing here? Thanks in advance, Yossi.
Hi,Do we have Lead() & Lag() functions in the Looker Studio fields?if not then what are the alternatives which can be used to serve the same purpose Looking out for Lead() & Lag() functions while creating a field in Looker Studio.
Hi there, does anyone know a way of seeing how many tokens my looker studio reports are using? And the amount we have left. We are exploring the option of upgrading to GA4 360, but before doing so, want to make sure we won’t still be going over our limit of tokens. Thanks
Hi, is there any way to disable the sort in dashboard table? Thanks
Hi, i am trying to run a query to select information from two tables. i am getting syntax error near ‘join’The main grid has the bulk of the info (LOADS). There is a second table below this (LOAD_PAY_INFO_DETAIL) which has rate and payment information. both tables have the column LOAD ID. I have tried a few different ways to get this to work, but i am stuck. you can see the jist of the query below (please help): select * from loads where ProductID='LOG' and Date_In> '2021-05-31'JOIN Quantity, Rate, Uom ON LOAD_PAY_INFO_DETAIL
We are moving from an instance hosted by our company to an instance hosted by Looker.We need to move our connections to the Looker hosted instance.We want the new database connections to be secure and fast.How do I ensure that ssh tunnelling is fast? In my experience, ssh is slow. We want to just use a VPN but that is not an option to connect to Looker. A VPN would be both fast and secure. We need an answer as soon as possible because the old looker instance is being depreciated.Thanks
I want to know if there is a way to embed a visualization pane in Appsheet app to interact with the data.
So I have this task to retrieve data from a looker iframe. Like when a user clicks on a particular order id then I can navigate to the order details which is a web page of my application.I don't want to do it within the looker dashboard. I want to move in and out of the looker iframe. Any help would be really appreciated.
I’ve created a new project in development mode. I want to configure it to push it in a repo so other developers can access it. When configuring git I’m choosing “Use user attributes for username and personal access token”. I’ve created user attributes to pass my github username and access token. I can select them from a dropdown menu in the development Mode Credentials section. that’s great. However I don’t understand what username and access token I should use for the Production Credentials section. I’ve used the same as in the development mode credentials section but I have the following error: Verify authorization credentials failedYour development HTTPS credentials are OK but the production HTTPS credentials are failing to authorize to the remote (Using HTTP/HTTPS authentication with username attribute "Github Username" and password attribute "Github Token" for development, and with username and password for production) What’s the differences between Production Credentials and Dev
Last tested: Sep 26, 2019 This generally occurs when the user's email domain (eg @looker.com) hasn't been added to the 'Authorized Domain' list on the OAuth side.This can also occur if the user's domain has not been verified on the GSuite / Oauth side.Note that even if the user's email address ends in the correct domain (eg @looker.com), that does not necessarily mean that it is registered with GSuite under the looker.com domain. The user must be registered with the correct GSuite account for that domain in order for the "hd" field to be passed in the Decoded ID Token that Looker receives from OAuth, which is the parameter used to match the user's domain against the Authorized Domain list on the OAuth side. This content is subject to limited support.
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.