To create dynamic tiers in LookML, you can use Looker's advanced modeling language to define a measure with tiered thresholds. The tier thresholds can be calculated based on a measure's…
Looker is a powerful business intelligence and data analytics platform that enables organizations to access, analyze, and visualize their data in a more meaningful way. In this blog post, we'll…
What Looker is: Looker is a data-discovery platform that helps companies make better business decisions through real-time access to data. No matter the size, data can be analyzed within Looker’s 100% in-database and browser-based platform.…
LookML (Looker Modeling Language) generates abstracted SQL and provides a modeling layer between the database and the user. It is Looker’s proprietary language that provides an abstraction layer for SQL…
Looker is a business intelligence and data analytics platform that allows users to perform table calculations. Table calculations are mathematical operations performed on columns in a data table to calculate…
Bucketing can be very useful for creating custom grouping dimensions in Looker. There are 3 ways to create buckets in Looker: Using the tier dimension type Using the case parameter Using a SQL CASE WHEN statement in the SQL parameter…
These best practices reflect recommendations that were shared by a cross-functional team of seasoned Lookers. These insights come from years of experience working with Looker customers from implementation to long-term…
1. How do I reference a derived table within the SQL of another derived table? You can use ${view_name.SQL_TABLE_NAME} in the SQL of a derived table to reference the PDT…
Case enables you to bucket results with case logic. While you can write raw SQL CASE statements instead, using case will create a drop-down menu for your users in the Looker UI. These are primary…
Looker Blocks are building blocks--pre-built pieces of code that you can leverage to accelerate your analytics. From optimized SQL patterns to fully built-out data models, custom visualizations to weather and demographic…