About Brett_Sauve

Brett_Sauve · 06-22-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. NOTE: When this entry was originally written, Looker users needed to use the following strategies to properly calculate certain metrics. Symmetric aggregates rend...

Brett_Sauve · 03-27-2022

This content, written by Brett Sauve, was initially posted in Looker Blog on Dec 2, 2014. The content is subject to limited support.A lesser known feature of some SQL dialects is something called the "window function". While MySQL users will be left ...

Brett_Sauve · 12-29-2016

In Looker 4.0, we introduced the option of “new LookML”, an improved LookML syntax that addressed some of the challenges with the original, YAML-style LookML. It has many benefits that you can read about in New LookML — Why? Instances initiated on Lo...

Brett_Sauve · 06-02-2016

As of 3.48 the now() table calculation will evaluate in the user or query timezone, falling back to the application timezone when no query timezone has been set. As a reminder, this is what those different timezones mean: Application Time Zone: This ...

Brett_Sauve · 04-08-2016

Some users have wanted greater control over how fields are grouped in Looker’s field picker. Looker 3.44 adds the new group_label parameter to let you group fields together, even within the same view. Existing Things You Could Already Do Since 3.20 i...

Brett_Sauve · 07-15-2020

The type: list measure (docs here) is meant for this purpose.

Brett_Sauve · 06-12-2020

Hey @lmheath, are actual_transactions and budget_transactions related in any way? Or, are they two unrelated sets of transactions? I think the confusion you’re having is probably that all 3 tables have a common key of nominal_code, and so you have a ...

Brett_Sauve · 11-15-2016

@bgig I can see where you’re coming from, I can open a feature request for you to potentially change that behavior.

Brett_Sauve · 11-07-2016

@bgig and @ross2 I looked into this a bit more and found that the field groups should only start expanded if you only have a single view in your explore. For explores with multiple views (aka that have joins) they should start collapsed. Does this ap...

Brett_Sauve · 11-04-2016

@bgig I think that Looker will expand a list only if you’ve selected a field within it. Otherwise, the list should be closed by default. I don’t think it’s possible to modify either of these behaviors.

My Stats

Brett_Sauve's Bio

Badges Brett_Sauve Earned

Recent Activity

The problem of SQL fanouts

A window into the soul (of your data)

Legacy Feature Notice: Old Style YAML LookML (Looker 4.4+)

Now() Table Calculation Function Has Better Timezone Handling (3.48+)

Grouping Fields Within Views (3.44+)

Re: Concatenating rows in a table

Re: Actual versus Budget joins

Re: Grouping Fields Within Views (3.44+)

Re: Grouping Fields Within Views (3.44+)

Re: Grouping Fields Within Views (3.44+)