How to best design for unique users count
Hi, Trying my luck with a new topic as I have not found anything yet. We have daily aggregated data with certa...
Modeling
Building a healthy project - and keeping it that way. Share your stumpers and successes with data management, performance optimization, SQL, LookML, caching, and more.
Forum Posts
Hadoop ecosystem deployment steps
I am trying to setup all projects from Apache Hadoop stack in one cluster. What is the sequence of setting up ...
How can I disable Total for some metrics?
Is it possible to not show any value on total for certain metrics? .I am not using table calculation.
Distance between addresses
What is the best way to calculate the distance between two addresses using Looker? These are U.S. addresses wi...
Using two string fields to filter a date range dynamically
Hi everyone, so this one is a doozy… I’ve been running up against some serious limitations with the built in d...
Dashboard API LookML formatting issue
Hello, i’ve been working on a project that involves taking the lookML from a Dashboard using the /dashboards/l...
Export Looker data to Google Sheets
When I use the ImportXML functionality in Google Sheets to bring Looker data into a new Google Sheet, the func...
Creating a date range filter based on column in table
Hi,I have data for multiple skus across the country (sku name, sales date, selling price, volume sold, revenue...
Aragonite - LookML validation issue
Developing in project on release 22.8.32 with Legacy LookML enabled (Aragonite setting). When team member swit...
Set parameter value in a different view
Hello! I have a view that has a parameter. It is structured just like thisview: table_1 { derived_table: { sql...
LookML Parameter
This example is provided:parameter: number_of_results { type: string allowed_value: { label: "Less than 500" v...
Filtering an additional field based on a dashboard filter
Is there a way to filter a field based on a dashboard filter? I’ve been checking out templated filters, but I’...
Creating measures by channel
Hello! I have this project have been working with for the past few days now, which is to create a view from a ...
SQL Trigger Value - First Week of Year
Hi there!I’m finding the SQL Trigger Value logic a bit confusing. I’m working in Amazon Redshift, and looking ...
Min/Max of a Timstamp Breaks Timezone Conversion
In our looker instance, we have a view that takes the min/max of a datetime:view: view_name { derived_table: {...
Finding closest matches by name in BigQuery
We’ve all been there before: someone gives you a dataset without ID’s, keyed only by name. You either file it ...
NDTs and first day of the month
I have an issue for an NDT I created. I have a filter in its creation which states as follows: filters: { fiel...
Is there a way to set session context to the SQL code generated by Looker?
Hi there,I need to set session context before the SQL code to be able to retrieve results from the DB.sp_set_s...
Creating a dynamic URL that links to different dashboard
I’m trying to link two dashboards together because it seems like looker doesn’t support dashboards having sepa...
Best practice: writing views in BigQuery vs Looker
We have a daily data feed to BigQuery for most of our data tables. In the past we used SQL Runner in Looker to...
Star schema tables to Looker model
Hi, we’ve been using Looker for 2+ years without any previous experience with this tool. We have all data stor...
Can you build utility functions in liquid?
We have a requirement which will cause us to have to conditionally format the HTML dynamically for currency va...
New LookML runtime issue with multiplication by constant
Our model has many measures calculating a percentage defined as:sql: 1.0 * ${gmv_variance_yoy_same_weekday_las...
SQL Error: 0 when scheduling looks to google sheets
Hi All,I have created a look (that has pivoted date columns) that I have scheduled to update google sheets. Af...
Validation Failed error while creating new connection
As looker UI part is updated at database connection. I am trying to create bigquery connection to looker while...
3 month rolling COUNT using lookml
Does anyone know how can i get this ?I want to create rolling 3 month count of a measure .So basically if i wa...
Does Looker no longer produce the `non-uniqe primary key` error when a pk is not unique?
I wanted to demonstrate how symmetric aggregates work, and how, if the designated primary keys are not, in fac...
How to update case statement in join to use aliasing instead?
I have a report that’s running off an Explore in my model, but one of the joins to a view needs to be updated ...
Suck in validation loop
I click "validate LookML", get the spinning icon that looks like its validating errors, then it quickly stops ...
Convert String ($1,234.50) to Number field
I have a string field that contains a dollar figure of total cost. It is a string field but I need it to be nu...
