keep geetting: "columname" must appear in the GROUP BY clause or be used in an aggregate function
Hello !I am trying to do a case when using two measures but I keep getting the same error and already tried ev...
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
Decimal
Hi, is there a Looker formatting option that excludes decimals numbers and does not round the result?For examp...
yesno dimension with several conditions
Hi folks, I must be extremely dense, but I can’t get this to work and I can’t seem to find an example here tha...
Dynamic field selector when we don't know the number of fields
Hi community! I have a bit of a tricky case. We want to give the users the option to select with a parameter w...
Using order_by_field with dynamic dimensions using parameters
I defined a dynamic dimension that I use as filter, as described examples here and here.For example one option...
Can you define order_by_field by multiple?
I have a dimension of type string that contains multiple numbers inside of the string and I'd like to order th...
Values on the week 1st day
Hi,I am trying to create a measure which only brings in value for the first day of the week.I tried to create ...
add dimensions as they appear in JSON column
We’ve got a JSON column with varied and often-changing keys. I want each of those keys to be a dimension.What ...
How to extract every 100th row in looker
Do you know, how to extract every 100th or nth row in looker?
Best way to replace table calculations for month over month retention/results
I need to track 3 data points month over month that all have to do with the volume of partners on our delivery...
Bigquery challenges
@EveryoneJust checking - what are major challenges - expected when we set looker via bigquery
How to set users permissions in a single table?
Hello all,I need to prepare an user matrix access and separate some fields in just one table for different use...
Combine Column Data
How would I have one of my columns list the data in a single cell instead of on separate cells?Example, trying...
Timezone conversion for a specific dimension
Hi,My Database timezone is set to UTC. I use mysql. The database version is MySQL 5.7.In one of the reports, I...
Convert minutes in integer format to "H: MM: SS" format
I have a measure that gives me the total minutes of use in a dashboard in integer format, i want to convert th...
Same Code in Dev and PreProd but Errors in Preprod Environment but not in Dev
Hello , I had an question on Looker different environment : I am using same code in Dev environment and Prepro...
BigQuery Data Transfer Service for Google Ads Partitioned Table Joins
Hello,I’m utilizing BigQuery Data Transfer Service for Google Ads to pull Google Ads Data then bringing the ta...
Looker Block Tutorial
Hi all!Can you share a link with me to on how to add a looker block to a project?Thanks
Creating a NDT column by concatenating two fields
Hello, I want to create a column in an NDT that concatenates two fields. view: ndt_sessions { derived_table: {...
How to dynamically calculate an average
Hello, I am trying to dynamically calculate averages. For instance, 3 columns: Detailed level: Row 1: total sa...
Case When in Custom Fields Dimension
Hi,How to create Custom Fields Dimension with Case when conditionsi have custom fields dimension and the resul...
System activity explores : adding drill fields
Hi guys - does anyone know if its possible to create Drill fields for System Explore fields?Eg... a dashboard ...
Flag/merge rows with a parameter
Hi, I have the following table for exemple Id Status Uptated_at 123 1 01.10.2021 123 2 02.10.2021 1234 1 1.10....
Marketo - Send list type object from Looker to Marketo
Hello,I’m using Looker to send data to Marketo. Every fields work well, except one, that is a list of invoices...
Getting a Datagroup Trigger Value to use in LookML
This might be a long shot question, but I would like to know if there is any way I can get the trigger value t...
How unpivot a table in LookML?
I have a table with the following structure:month | cost_cat1 | cost_cat2 | cost_cat3But I need this one:month...
Define series_types for pivoted measures meeting criteria?
I have a LookML dashboard file that I want to show bars for monthly values and lines for running totals. I kno...
How to Sort to ascending a date field in a drill Down table
Can We Sort a Drill down Table date field in ascending order.
how to do percentage change on pivoted data
I was trying percentage change measure where I have the date column and the total revenue I pivoted by product...
how to run project
I have do python table,but I don't know how to run the program and test it.
