About cutler

cutler · 10-30-2015

Looker Coalesces by Default By default, Looker coalesces sum measures with zero. This gives us a nice “0” display rather than a NULL; in most cases we don’t care about the distinction between “zero” and “no data”. If we’re talking about daily sales, ...

cutler · 05-19-2015

Powered by Looker is a neat way to share data with the world. If you’re interested in creating a proof of concept, I highly recommend checking out this post. If you’re having issues with your embedded Looks and/or dashboards, making sure the embed UR...

cutler · 05-14-2015

It’s not uncommon to want to display ‘0’ instead of NULL. Does anyone have any good techniques for handling this? I usually suggest using SQL’s COALESCE() function to swap a NULL out with a zero, but I’m wondering if people have any better ideas. Her...

cutler · 03-13-2015

Looker’s default world (choropleth) map reads in “full” country names or ISO 3166-1 alpha-3 country codes. It’s a great way to visualize a world of data, but it requires fairly specific data. If you don’t know what format your data need to be in, we’...

cutler · 01-20-2015

About This Block A simple funnel is a great way to look at events or transactions. Starting with just a few events, you can quickly get a sense of how users traverse your site or application. By adding in more events, you can add much more depth to t...

cutler · 10-02-2018

The feature isn’t implemented, but you can mimic it by creating table calculations using pivot_where() or something or something similar to duplicate the columns you do want and then hiding the entire underlying field.

cutler · 12-27-2017

Way slick, never crossed my mind!

cutler · 08-07-2017

Just a quick update to @sam8’s comment above: As of Looker 4.18 we also add an identifier to file names so that even files generated at the same time should have unique names.

cutler · 08-08-2016

Yeah, @JohnLemberger as @msh210 suggested, hiding the series in the visualization is probably the best option for the immediate term. I’ll make sure that our product folk get eyes on this, though

cutler · 06-10-2016

I was able to get the feature to work on Learn using this (someone nonsensical) Look. The feature doesn’t apply to the string No, though, but on false conditions. Table calculations display a true as Yes and false as No. If you’re not able to get the...

My Stats

cutler's Bio

Badges cutler Earned

Recent Activity

Displaying null values in sums

Troubleshooting Looker SSO Embed URL Generation

Ideas for displaying NULL values as 0

Accepted country names

[Analytic Block] Simple Funnel

Re: Hide Pivoted Column

Re: Creating hyperlinked button dimensions

Re: Scheduling (unlimited) Results to S3

Re: Hide Pivoted Column

Re: RETIRED: Filtering in Visualizations using Table Calculations (3.28+)