Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started142 News & announcements125 Who's hiring494 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1832 SQL323
Exploring & curating dataExplores560 Dashboards & looks1564
Application developmentEmbedding Looker / Powered by Looker155 Open source projects54 Looker API378
AdministrationUser access & management70 General Looker administration452
Data science & analyticsGot a question?83 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1739 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知50 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Welcome to the Looker Community

9,067 Topics
18,112 Replies
49,068 Members

Find answers to your questions
Stay up to date on the latest topics
Ask questions and help others

Ask your question

Getting started

New user? Click here to get started in the Community.

Events & (Virtual) Meetups

Learn about our awesome events

Looker Connect

Level up your knowledge with Looker's training hub

Community Groups

Find others interested in the same topics as you.

What's New

Get the latest news about Looker & the Community

The Kitchen Table

A collection of Looker knowledge for you to explore

Stay up to date with the latest

Customer Success Newsletter - June 2022

Forum|Forum|10 days ago

880

Product Announcement: Introducing new in-app tutorials & onboarding guides

Forum|Forum|5 months ago

4780

How you helped make Looker better in 2021

Forum|Forum|4 months ago

3320

About Video Tutorials 🎥

Forum|Forum|1 month ago

960

Recently active
Categories
Help others

raivivanNew Member

SQL

How to automate commit of code architecture to an Azure DevOps Repository?

I am working on an automation, that will create repositories and pipelines based on standards and requirements. To create repositories and pipelines, I have used Azure DevOps REST APIs and it is working fine.Now, along with creating repo, the requirement is to also commit a code structure - basic DevOps architecture of application - as initial commit. Using Azure DevOps REST API, I can find that we need to mention file by file and there is no option for bulk commit - I have also tried forking the seed/base repo while creating the new one but this will also bring the commit history and repo properties of base repo to new one and it is not expected. Also, the icon of forked repo is different and I believe, it is treated differently than other repo.Can anyone please guide me on how to approach this requirement and how can it be implemented - to automate commiting a bulk code (base architecture) to a newly created repo?

8 hours ago

Department of Customer LoveModerator

Technical Tips & Tricks

Other Buckets Using Table Calculations

Looker will not be updating this content, nor guarantees that everything is up-to-date. You can create ad hoc custom groups for dimensions without using logical functions in Looker expressions or developing CASE WHEN logic in sql parameters or type: case fields when the Custom Fields Labs feature is enabled and you have permissions to create custom fields.You can also create ad hoc custom bins for numeric type dimensions without needing to use logical functions in Looker expressions or needing to develop type: tier LookML fields when the Custom Fields Labs feature is enabled and you have permissions to create custom fields.When you are building a chart or table off a high-cardinality dimension, you might want to lump all low-frequency dimensions into an Other bucket to avoid cluttering your output. Referencing the :total of a measure in a table calculation makes other bucketing possible without the need for any LookML coding.Starting off with a count of events on our Looker instance: T

781

21 hours ago

DSharmaNew Member

Looker API

Using Looker API for LookML Dashboards

We’re trying to use the LookerAPI to work with LookML dashboards and recreate specific charts in Jupyter notebooks. We’ve been able to do this using User Defined Dashboards, but are running into issues applying the same logic to LookML dashboards. Specifically, we use functions such as sdk.search_dashboard_elements and pass in a dashboard_id for user defined dashboards. However, this doesnt work for our LookML dashboards. Do you have suggestions for another way to use this function on LookML dashboards? Additionally, on our UDDs we loop through our tiles which either have query_id's or merge_result_id's and store the queries, run them using _sdk.run_inline_query, and save the results in a pandas dataframe. The tiles on our LookML dashboards don’t have these attributes, so we’re unable to access them in the same way. Do you have suggestions for another way to access these tiles? More generally, if there are tools and functions available that would more seamlessly allow us to use the Loo

21 hours ago

OlaNew Member

SQL

Only find filters that have been used

Hi,I have a dashboard with lots of filters and I’m trying to create a user activity dashboard where I could check how often each filter is being used. When using Query Filters all the available filters for a dashboard show in one column even the ones that have not been used by a user.

1 day ago

YiannisENew Member

Dashboards & looks

Aligning different views in a dashboard

Hello, I am relatively new to Looker, so please excuse me if its an obvious answer. I am creating a few different views, that I then want to align on a row level. I am attaching a screenshot of how it currently looks. Since the second view has a pivoted dimension too, there is an extra line, leading to the mismatch of the rowsIdeally I would like to be able to adjust the header size on the first view to match the size of the two headers on the second, leading to the alignment of rows. It seems like I can adjust the width of the view, but not the height of it (or have something similar to Tableau’s “fit to width/ height”). Any ideas would be very appreciated. An additional question I have is why on my second view, the very first% column is formatted based on my conditional formatting. It seems to be uniformly applied to all the columns including that dimension, apart from the first. If you reached until here, thanks a lot for your time :)

1 day ago

K Young PCLNNew Member

Explores

Stored chart customization parameters

In LOOKER, If it is needed to create a group of metric performance charts, each with individual customzations (max, min, step size, scaling, etc), can these sets of custom parameters be stored in a CSV file or SQL table to be accessed and applied? If possible, we want to avoid the need to manually edit the charts every time we generate a new set of charts. Thanks.

1 day ago

izzyGood Looker

Dashboards & looks

CJCNew Member

SQL

Date Filter CASTING

Very new to Looker. What determines the internals behind how Looker converts a filter to a datetime? For example, I have a field that’s setup in Looker as follows:dimension_group: some_start_date { type: time timeframes:[time, hour_of_day, date, week, day_of_week, month, month_name, quarter, year] sql: ${TABLE}.some_start_date ;; }When I pull this field in and look at the generated SQL, it is converted to:DATEPART(hh, CAST(schema.some_start_date AS DATETIME))The table field is a DATETIME2, so there are some errors that occur when the cast to a DATETIME happens. Looking to better understand how this works in the backend so I can implement a fix. Have been reading the documentation on this and haven’t found exactly what I’m looking for yet, and was hoping someone could point me in the right direction of things to research. Thanks! Edit: Found https://docs.looker.com/data-modeling/learning-lookml/how-looker-generates-sql and am currently looking at it

1 day ago

Welcome

Rules, announcements, and important information

Looker development

Developing LookML, writing SQL, and modeling data

Exploring & curating data

Dashboards, Looks, Visualizations— it all happens here

Application development

Extensions, open source tools, the Looker API, and embedding Looker

Embedding Looker / Powered by Looker

155 topics
335 Replies

Administration

Looker set-up and management

Data science & analytics

Everything from mean() to machine learning

The Kitchen Table

コミュニティフォーラム (Japanese)

コラム

69 topics
8 Replies

raivivanNew Member

SQL

How to automate commit of code architecture to an Azure DevOps Repository?

8 hours ago

DSharmaNew Member

Looker API

Using Looker API for LookML Dashboards

21 hours ago

OlaNew Member

SQL

Only find filters that have been used

1 day ago

YiannisENew Member

Dashboards & looks

Aligning different views in a dashboard

1 day ago

K Young PCLNNew Member

Explores

Stored chart customization parameters

1 day ago

izzyGood Looker

Dashboards & looks

New dashboards (beta) HTML options

1 day ago

Adrian_TriteanuMember

LookML

User defined parameter default value

1 day ago

WM_NLustig

Explores

Identifying duplicate results in a column

1 day ago

CJCNew Member

SQL

Date Filter CASTING

1 day ago

Adam_WeinsteinNew Member

General Looker administration

Long view names truncated?

I’ve noticed that view names longer than ~30 characters get truncated in the project view. Anyone else notice this behavior? Is this new, or has this always acted this way? Because of our naming convention, we have some long names, so to differentiate between files you need to mouse-over currently.

1 day ago

Upcoming events

Most active members

No activity yet!

Show full leaderboard

Sign up

Already have an account? Login

Social Login

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

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.

This file cannot be downloaded

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