About lindsey1

lindsey1 · 06-23-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. It is common to compare things like the sales from a specific week of this year with the sales from the same week in previous years. Let's say you want to compare...

lindsey1 · 05-16-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. If you have multiple schemas with shared tables in your database, these shared tables can be represented by a single view file in Looker to prevent duplicate Look...

lindsey1 · 05-12-2022

Looker will not be updating this content, nor guarantees that everything is up-to-date. If you would like to count (not count_distinct) a field that is not the primary key, you can do this by creating a measure of type: number and performing the coun...

lindsey1 · 10-01-2020

Looker_Hack is back with our first ever two-day hackathon for Looker Application Development. Over these two full days of hacking, we’ll provide everything that you need to build something incredible on the Looker platform.You’ll be able to attend li...

lindsey1 · 02-09-2016

As of Looker 3.40, we have introduced dimension drilling and drill menus. Drill menus allow for more data exploration and agility. What can you do with drill menus? Drill menus allows you to: Drill into a row by any other dimension value (i.e. hierar...

lindsey1 · 03-28-2017

@kshah7 Using Looker’s fiscal_month_offset also gives some benefits for filtering! If you specify a fiscal_month_offset in your model, then you can filter based on fiscal years and fiscal quarters (these options will appear in the filter dropdowns fo...

lindsey1 · 03-22-2017

@kshah7 we don’t currently have a way to start a fiscal year on any other day besides the first day of the month. This type of transformation is very hard to deal with in SQL, and we haven’t figured out a good way to make that possible. But I’ll pass...

lindsey1 · 03-22-2017

@amock we initially decided not to add a fiscal_month timeframe since that isn’t commonly used as far as we knew. However, if this is actually common or something you or others would like to see, we can easily add this as another fiscal timeframe!

lindsey1 · 01-13-2017

@Manoj_Pushpanat Are you using pivots? If so, I think you’ll want to use pivot_index in your table calculation to refer to the pivoted columns. This will cause the table calculation to appear on the very right side of the table (as opposed to under e...

lindsey1 · 02-12-2016

This looks like a bug with getting the Dashboard LookML. Filing this with eng.

My Stats

lindsey1's Bio

Badges lindsey1 Earned

Recent Activity

Comparing a Previous Week to that Same Week Last Year

Multiple Schemas with Shared Tables Can Use a Single View Accessed with Parameterized Table Names

How to count a non-primary key

Hack@Home Hackathon

Hierarchical Drilling and Drill Menus (3.40+)

Re: Fiscal Month Offset Parameter 4.8+

Re: Fiscal Month Offset Parameter 4.8+

Re: Fiscal Month Offset Parameter 4.8+

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

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