Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications
Last Tested: Mar 17, 2019Consider this URL: https://learn.looker.com/explore/e_commerce/order_items?qid=9wqqjztJGVrVI6BZJejzTH&toggle=filhttps:// <- All Looker-hosted instances use SSL, which means that you need to use https instead of http.learn.looker.com/ <- Most hosted instances have the form hostname.looker.com. There are a few exceptions. explore/ <- this word is hard-coded saying that this page is an explore page.e_commerce/ <- this is the model name of the explore you're looking at. This is why you can't have duplicate model names, even across projects (note that the project name is not in the URL).order_items <- this is the name of the explore that you're looking at.? <- The question mark here means that we're adding a parameter to the URL. You can choose to leave off the question mark and everything after it to just navigate to the blank explore.qid=9wqqjztJGVrVI6BZJejzTH <- qid stands for query id. This is technically the query slug, not the query id
The “transparent” color in Looker can be used to hide many different elements of a visualization. One useful way to use this color is to selectively hide value labels. Currently, in Looker, the value label setting operates on all value labels; it’s not possible to apply labels to specific series. Fortunately, it’s very easy to work around this by using the transparent color in the ‘Series Colors’ option. (Sneak Peek! We will soon be introducing additional visualization settings that will make this method unnecessary. Keep an eye on those release notes!) Here’s the result set I’m going to work with: In the image below, I’ve toggled on ‘Value Labels’ and ‘Totals Labels’. I’d like to hide the value label for the green ‘Yes’ series but keep the others. The input to ‘Value Colors’ corresponds to the series in the order that they are listed in the legend. By using white, transparent in the ‘Value Colors’ setting, I’ve hidden the ‘Yes’ series.
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.
