Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

- - Knowledge base
Product Announcements
Events
Groups

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2115 Topics

Most views

Recently active Most replies Newest first

Department of Customer LoveLooker Staff

published in Blog Archives

Unleashing data insights to your entire organisation: Q&A with Appsflyer

This content, written by Áine Dundas, was initially posted in Looker Blog on Feb 24, 2020. The content is subject to limited support.In this blog, we talk with Alexandra Sudilovski, Head of BI at Appsflyer. Appsflyer is a rapidly growing SaaS company, and we wanted to learn more about how access to data has helped to fuel that growth. Hi Alexandra! Could you share a little about your background in data and your current role in Appsflyer? I am a BI expert at — a mobile attribution and marketing analytics platform that helps application marketing teams around the world make better decisions. We enable marketers to measure everything from impressions and clicks, to installs, purchase activity, ad revenue, and so much more. One of our main responsibilities as a BI team is to provide data and make it relevant, available and accessible to all our internal departments. That’s no mean feat! I’ve been working with Looker for about two years already, and I’m focused on really integrating analyt

Department of Customer LoveLooker Staff

published in Blog Archives

Looker and Vertica - geospatial analytics

This content, written by Erin Franz, was initially posted in Looker Blog on Dec 22, 2015. The content is subject to limited support.Vertica offers a suite of geospatial analytics functions with its HP Vertica Place package. This package enables storing and querying of geometric objects - translating locations into geometric points and regions into polygons. Common asks for measuring distance, length, area can be completed directly in Vertica and these requests are optimized at scale using spatial indexes and the underlying power of Vertica’s database. Because Looker performs all analytical workloads in HP Vertica, Looker can utilize these geospatial analytic functions to enable exploration and visualization of results dynamically. To demonstrate some of what’s possible, we’ll start with a table of bookings in Vertica that have associated latitude and longitude locations. When we query for a sample of the table, called locations, we see the following: select * from place.locations limi

Eric_LyonsLooker Staff

published in Technical Tips & Tricks

Use Python SDK to convert All Dashboards to Dashboards-Next on an instanceKnowledge Drop

Last tested: Oct 22, 2020 Love dashboards-next, but hate having to convert legacy dashboards one folder at a time? This script will convert them all for you. You just need to use the Python SDK, import looker_sdkimport csvimport pandas as pd import timei=0list_of_dashboards = []dashboards_next_list = []legacy = []# from typing import cast, MutableSequence, Sequence####Initialize API/SDK for more info go here: https://pypi.org/project/looker-sdk/from looker_sdk import methods40, models40sdk = looker_sdk.init40() # or init40() for v4.0 APIme = sdk.me()list_de_dashboards = sdk.all_dashboards()while i < len(list_de_dashboards):if sdk.dashboard(dashboard_id=list_de_dashboards[i].id).preferred_viewer == "dashboards-next":dashboards_next_list.append(list_de_dashboards[i].id)else: legacy.append(list_de_dashboards[i].id)i = i + 1time.sleep(1.0)print(i)#print("list of dashboards-next")#print(dashboards_next_list)#print("list of LEGACY")#print(legacy)n = 0 while n < len(legacy):sdk.update_d

mandy.chanLooker Staff

asked in Technical Tips & Tricks

Why does it show the faceted filter icon even though there aren't any faceted filters enabled?

The problem:Sometimes, you can encounter a situation where you see the faceted filters icon even though there aren't any faceted filters enabled on the dashboard and then when you hover over the faceted filter icon, you see this... The explanation:Some ways this can happen is if the you created a LookML dashboard and have it listen_to_filters and then turn the LookML dashboard to UDD, or if you've created the dashboard via the API and accidentally had the faceted filters listen to each other. The solution:Either way, simple solution for this is to recreate the filter. Harder solution would be to update the dashboard via API.

samLooker Staff

published in Technical Tips & Tricks

Which order do I write my join in sql_on?Knowledge Drop

Last tested: Sep 2020 It doesn't matter. According to docs, you can write the join in any order. Thus these two are equivalent:sql_on: ${order.user_id} = ${user.id} ;;sql_on: ${user.id} = ${order.user_id} ;; This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

Can I rename a dashboard tile title without editing the Look title?Knowledge Drop

Last tested: March 2021 No, a title for a Look-based dashboard tile title directly corresponds to the Look title. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Power up your Zendesk analytics with Looker Blocks® and Blendo

This content, written by George Psistakis, was initially posted in Looker Blog on Jan 25, 2018. The content is subject to limited support.Successful businesses know to never underestimate the importance of top customer support. As an integral aspect of the customer experience, effective support can contribute significantly to: Customer retention. A great customer experience and efficiently addressing issues inspires loyalty. Product development. Especially relevant for startups, but also valid as a company scales up. A great source of product validation and information for the product roadmap. Customer acquisition. A pleasant onboarding process increases the chances of converting them to paying customers down the road. Tools like are helping companies of all sizes provide stellar customer experiences through chat applications. But in order to ensure that the best support is being provided, just having a tool to handle the support requests isn’t enough. Companies also need a way to ta

Kento_TomineCommunity Admin

published in Technical Tips & Tricks

Can we apply pivot over dimension?Knowledge Drop

Last tested: Oct 14, 2020 Yes, we can by using type: list in Measure field.measure: list {type: listlist_field: first_name}dimension: first_name {type: stringsql: ${TABLE}.first_name ;;} *NOTEtype: list creates a list of the distinct values in a given field. If two or more string value are included in the calculation, the data are separated by a comma. Related Community post- Pivot over dimensionOur Doc- Measure Types - list This content is subject to limited support.

VincentLooker Staff

published in Technical Tips & Tricks

When looker is running in a clustered mode, where do we store the query cache?Knowledge Drop

Last tested: Aug 14, 2017 It’s on the local file system of whatever node ran the query, but node A can request it from node B.So if the user hits node A, node A looks up where the cache is (from the internal database), sees node B has it, requests it, node B sends it, and node A sends it to the user. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Creating a data driven culture: part 1 | The challenge

This content, written by Brian LaFaille, was initially posted in Looker Blog on May 18, 2020. The content is subject to limited support.Being a “data-driven” company has become a key goal for many businesses in the last decade. Enterprises big and small want to use the vast amounts of information they collect to drive revenue and steer company resources towards future goals. This can be easier said than done. While most companies are amassing data at an unprecedented rate, many are struggling to a true “data-driven culture” that sticks. In this five-part blog series, we’ll explore why this is still a challenge for organizations today, as well as introduce an actionable framework for setting up a successful data program. Defining data culture Before going any further, let’s define what we mean by data culture. As some of our Lookers have before, data culture can be thought of as a community made up of data-driven individuals across all departments and levels. These communities are whe

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

What is errorsfallback@looker.com?Knowledge Drop

Last tested: Sep 12, 2019 ProblemUsers will sometimes see the email address errorsfallback@looker.com in their SMTP logs; this is our error server where emails reporting exceptions will fall back to if their custom SMTP settings block our access to sending emails to Sentry.SolutionThe best way to change this behavior is to allowlist traffic to errorsentry.looker.com, but if that's not possible you can also change which email address to send exceptions to with the --error-emails-to=<s> startup flag. This content is subject to limited support.

Peggy_BeardMember

published in Technical Tips & Tricks

Can I include a comment in a custom field?Knowledge Drop

Last tested: Nov 20, 2019 Yes! A comment line begins with a #, just like in a table calculation This content is subject to limited support.

david.chiaramonteLooker Staff

published in Technical Tips & Tricks

Are custom filters preserved when changing other filters on a Look's schedule?Knowledge Drop

Last tested: Sep 3, 2019 Yes! If you create a report with a custom filter and save it as a Look, you can change other filters in the Schedule modal without affecting the custom filter logic. It acts as a "constant" filter that you can only change by editing the Look itself. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Query exabytes of data in AWS with Looker’s native support of Amazon Redshift Spectrum

This content, written by Bruce Sandell, was initially posted in Looker Blog on May 18, 2017. The content is subject to limited support.At the AWS Summit on Wednesday, April 19th, 2017, Amazon announced a revolutionary new Redshift feature called . Spectrum significantly extends the functionality and ease of use of Redshift by allowing users to access exabytes of data stored in S3 without having to load it into Redshift first. Based on the resounding cheers of the crowd at the Summit and early interest from Looker customers, it’s a feature that people are pretty excited about. Looker customers on Redshift can to maximize the impact of both technologies. To highlight the speed and power of Spectrum during his Keynote speech, AWS CTO Werner Vogels compared the performance of a complex data warehouse query running across an exabyte of data (approx. 1 billion GB) in Hive on a 1,000 node cluster versus running the same query on Redshift Spectrum. The query would have taken 5 years to comple

Department of Customer LoveLooker Staff

published in Blog Archives

Enhancing the data-sharing experience with the latest Looker Slack integration

This content, written by Ani McDowell, was initially posted in Looker Blog on Oct 13, 2020. The content is subject to limited support.Everyone today, regardless of role, department, or technical skill, needs access to data. But perhaps more importantly, they need data in the places they’re already working. Our product and engineering teams are making it faster and easier for everyone to get value from their data when and where they need it. We’ve approached this with a focus on three main themes: Deliver rich and interactive data experiences Empower users to quickly understand and explore their data Provide seamless access to data where users spend their time Part of delivering on that third pillar has included reimagining our Slack integration. Since announcing the beta for this integration during our launch, we’ve continued to improve upon it, bringing it out of beta and building out new features. With this release, we’ve added the ability to set custom, threshold-based alerts that

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

How do I show all of the values of a column in a liquid parameter's allowed value definitionKnowledge Drop

Last tested: Jun 11, 2019 Say you have a parameter with allowed values yes and no, but also want an option for end users to choose all values (essentially no filter applied).You can enter two double quotes "" in the value for the filter which equates to 1=1, such as:parameter: filter_for_yes_no_all {type: stringallowed_value: {label: "Yes"value: "1"}allowed_value: {label: "No"value: "0"}allowed_value: {label: "ALL"value: ""}} This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Performance Diagnosis: Network UnreliabilityKnowledge Drop

Last tested: Nov 2, 2018 In order to use Looker, end users need to make requests from their client browser to the Looker server. The Looker server usually lives on another machine than the one end users are requesting from, so these requests need to traverse a network (or networks).A network is a collection of connected machines capable of transmitting data amongst themselves. If a network has a route to another network by means of a router and routing table, machines in one network can transmit data to and from machines in another network. The internet is just a massive conglomeration of networks.If I'm at work within my office's network and I'm requesting resources from a Looker server hosted in Looker's VPC, I'm traversing multiple networks. In other words, the packets transmitted to and from our respective machines need to jump through multiple networks on their journey. When troubleshooting network unreliability, it's usually helpful to determine:what network devices are between t

romain.ducarrougeLooker Staff

published in Technical Tips & Tricks

Define a view to create a separate PDT that gets generated each day with a title like “pdt_20190219”Knowledge Drop

Last tested: Feb 19, 2019 Turns out we can use liquid in the create_process part of the derived table for this!We use this in the first sql_step to define the name of the PDT to generate.view: yesterday_data {derived_table: {explore_source: order_items {column: pk2_created_date { field: order_items.created_date}column: pk2_brand { field: products.brand }column: total_orders {field: order_items.count }filters: {field: order_items.created_datevalue: "1 days ago for 1 day"}}}} explore: table_date {}view: table_date {derived_table: {datagroup_trigger: incremental_pdt_default_datagroupcreate_process: {sql_step: CREATE TABLE db_scratch.table_{{'now' | date: "%s" | minus : 86400 | date: "%Y%m%d" }} AS ${yesterday_data.SQL_TABLE_NAME} ;;sql_step: CREATE TABLE ${SQL_TABLE_NAME} AS SELECT 1 as one ;; This content is subject to limited support.

molly.lippsettLooker Staff

published in Technical Tips & Tricks

Is it possible to connect to the API without an SSL connection?Knowledge Drop

Last tested: Oct 16, 2020 Nope - connecting to the API requires an https connection with a valid cert. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

JOIN 2020 Recap: Bringing the digital data conference to you

This content, written by Pedro Arellano, was initially posted in Looker Blog on Oct 23, 2020. The content is subject to limited support.JOIN, whether in person or “@Home,” is about bringing the Looker community together. It’s a time to highlight the latest product updates, share tips and best practices, and ultimately inspire one another to solve problems and create opportunities with data. While JOIN was a little different this year, I’m grateful that the switch to a virtual format allowed us to engage with our broader, global community. We hosted speakers from Santiago to Toronto, San Francisco to Tel Aviv, and many places in between. I joined from home in San Diego, California. The switch to digital also allowed attendees to participate in live, interactive sessions, and learn at their own pace with on-demand content. For those of you who spent the week with us, we’d love to and invite you to register for our “What’s New in Looker November 2020” webinar to make sure you’re leveragi

chris.seymourLooker Staff

published in Technical Tips & Tricks

Scientific notation with n significant figures in table calcKnowledge Drop

Last tested: Oct 25, 2018 You can replace n with the number of sig figs in this formula:concat(round(${view_name.field_name}/power(10, floor(log(${view_name.field_name}))), n-1), " x 10^", floor(log(${view_name.field_name}))) Example with n=2:concat(round(${orders.count}/power(10, floor(log(${orders.count}))), 1), " x 10^", floor(log(${orders.count}))) This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

6 ways to integrate a data strategy into your product workflow

This content, written by Erin Franz, was initially posted in Looker Blog on Mar 21, 2018. The content is subject to limited support.Even though most product and engineering organizations today are collecting tons of data, most only use a fraction of what is available. This is often due to competing priorities or lack of implementation experience in data strategy. Looker and are working together to make data-driven product development workflows a reality. There’s no silver bullet when it comes to making data-backed decisions the norm, but there are steps you can take to shift the culture of your team, or even your company. 1: Expand your definition of data Data from instrumented products is increasingly valuable to product teams because it shows how users interact with the product directly. But data from the product itself isn’t the only source of information you can use to improve your product and workstreams. Data from issue tracking tools can provide valuable insight into historical

paolaLooker Staff

published in Technical Tips & Tricks

What are the default groups in Looker?Knowledge Drop

Last tested: Jan 21, 2019 In an open system the default groups areAll Users Users (with access to Shared Folders)In a closed system, there is no default group. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Steps for getting started with data-driven marketing

This content, written by Matt Ryan, was initially posted in Looker Blog on May 10, 2019. The content is subject to limited support.No matter your business size or industry, doing more of what’s working and less of what’s not is a no-brainer. With data-driven marketing, you can not only uncover insights on your prospect and customer behaviors, but you can further leverage those insights to inform the strategies that impact the success of your business. Check out these steps for getting started with data-driven marketing at your organization: Step 1 - Define your goals Setting your team up for success starts with defining the goals and outcomes you want to achieve. Whether you’re looking to increase the number of new customers acquired, increase website visits, or grow marketing-generated revenue, setting specific and measurable goals will help your team map out the strategies that will lead to a successful outcome. When developing a plan for the entire team, select marketing channels in

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Can I use Table Calcs to find the total number of rows in my result set? (max)Knowledge Drop

Last Tested: Jan 21, 2019 Yes, you can use the formula below to see the max number of rows in your result set.max(row()) This content is subject to limited support.

1
...
55
56
57
58
59
60
61
...
85

Page 58 / 85

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Powered by inSided

Terms of Service

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 of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

or

Username or Email

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

© 2022 Google. All rights reserved.
Privacy | Terms | Community Guidelines