User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started22 News & announcements96 Who's hiring325 Release notes (archive)64
Looker developmentLookML1113 SQL233
Exploring & curating dataExplores370 Dashboards & looks930
Application developmentEmbedding Looker / Powered by Looker80 Open source projects40 Looker API239
AdministrationUser access & management11 General Looker administration337
Data science & analyticsGot a question?37 Share your best practices2
コミュニティフォーラム (Japanese)ニュースと告知25 ヘルプとサポート6 コラム42

Ask question / Create topic
Login

LookML

LookML design patterns, best practices, hacks, and knowledge sharing

1,113 Topics
3,435 Replies

When you subscribe we will email you when there is a new topic in this category

1113 Topics

Recently active

Most replies Most views Newest first

Question about spinning up a new looker instance

We are spinning up a new looker instance for a new product. I am having trouble getting started server is 500 when I pop in the git url for the repo i just created. Help! 2015-03-14 02:57:49.908 +0000 [ERROR|01358|] :: non-absolute home org/jruby/RubyFile.java:754:in `expand_path' lib/helltool/model...

Article Sessions To Order count - or Sessions until other interaction

In a Visitors table, I had created a dimension for the Visitors’ Time to Order, as well as Time to complete several interactions. The Visitors table is derived from Sessions by grouping them by user_id. Time To Order was of course useful, but I found it would be great to separate those users who pu...

Article [Analytic Block] Measuring Activity and Engagement

About This Block Tracking users’ activity and engagement allows you to dig beyond a simple user count like Daily Active Users and begin to develop a deeper understanding of how customers are interacting with your product. Using this block will enable you to answer questions like: How much time are...

Article About the Analytical Patterns & Blocks category

Deeper dives into complex LookML analysis. Many articles will contain links out to learn.looker.com. To explore these in Looker, request a login from help.looker.com.

Article [Analytic Block] User Loyalty and Other User Attributes

About This Block Loyalty facts are attributes computed over the lifetime of each user, which helps us segment and understand our customer base. Segmenting customers/users by their behavior helps us explore the most important characteristics that differentiate each user group, and how we can target t...

Article [Analytic Block] Derived Tables Pattern

About This Block Often times our database doesn’t store information optimally for analytics. Rather than writing inefficient dimensions or measures to calculate what we want, derived tables allow us to create temporary tables directly in our database. With derived tables, you can perform analytics t...

Article [Analytic Block] Repeat Purchase Patterns

About This Block Repeat business is the key to success for most ecommerce companies. Figuring out behavioural differences between repeat and non-repeat customers and making more of them repeat customers can change your business for the better. Information about who are and who are not repeat custome...

[Analytic Block] Creating Custom Cohort Analysis

Looker has created this block to make analyzing data easier and more efficient. This Data Block is made available on an “as is” basis, meaning there will not be updates moving forward.Please note that this pattern expands on concepts described in Creating Custom Cohorts and provides opportunities fo...

How to Avoid Dividing by Zero

When creating percentage measures, it is often useful to make sure you are not dividing by zero in the percentage calculation. This can be done through the SQL function NULLIF(expression_1, expression_2). NULLIF takes two inputs. If the two expressions are equal, NULLIF returns a NULL. If the two...

RETIRED: Error: Redefinition of Field

The content of this article has been moved to a Help Center article.

About the Modeling category

General design patterns and best practices in modeling solutions.

Unknown substitution error

I’m getting an “Unknown Substitution Error” on one of my Explores. What does this mean?

About the LookML category

LookML design patterns, best practices, hacks, and knowledge sharing This category contains anything and everything LookML. If your post is specific to modeling, a LookML error, or a super cool analytical pattern you want to share, please make it in the appropriate subcategory.

1
...
42
43
44
45

Page 45 / 45

Powered by inSided

Sign up

Already have an account? Login

Social Login

or

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

*

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

or

Username

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

© 2020 Looker Data Sciences, Inc.
Privacy | Terms | Cookies | Community Guidelines