New field shows wrong values
I need to create a new field which shows only the users that reached a specific landing page of a website, wit...
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
Looker Custom Measure
We create a custom measure as a List of unique values The value that we try to get the unique values from is a...
GA4 to Looker data lag
I have a simple dashboard which includes graphs for purchase revenue and session medium.This is set to be the ...
GA4 Source/medium breakdown
On GA4 under the traffic acquisition report you can change the dimension to source/medium, however in Looker t...
LookML architecture/organization (w/ multiple customers)
What’s been your experience in organizing your lookML, specifically when provisioning reports to different cus...
SSO Embed localisation
I've seen this post (https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/SSO-Embed-locale-localisati...
Can I use a user_attribute for a filter title on LookML dashboard?
hello, I have a customizable dimension label based on a user attribute and I am having trouble using that valu...
Manage Data Models in Look Challenge Lab
I am working through the Looker courses on the Google Skills Boost site and the Challenge Lab for the Manage D...
Date_diff function in LookML
Hi, Can you help me understand why I am getting an error with the below date_diff expression in ML? I want to ...
Single Value Visualization - Showing 'No Results' as '0'?
I would like it to display the number “0” instead of No Results because the actual result is zero (e.g., 0 com...
README autogeneration
Is any way to turn off README autogeneration by Looker?It happens when you create view by Looker feature "Crea...
Does Looker has own Internal Git Repository
Considering our org policy, we are currently not permitted to connect any external Git/Bit repositories. I wan...
Max Date Time from Partitioned by Client
@izzymiller or anyone can you give some suggestion, if there is a simpler way to do it? We have clients, and d...
Site CTR from GSC
Hiya!I'm trying to modify a Looker report (https://www.metricized.com/looker-studio-templates/search-console) ...
Proposal for kurdish flag emoji
Introduction: The use of emojis has become an integral part of modern communication, allowing individuals to e...
How to get Day Name from date timestamp?
Hi, Looking to get the filter to work but the only function I can find is DAYNAME which gives me Mon / Tue / W...
How to aggregate the measure values to one dimension values
Hi team,My requirement says Sum of the field or aggregate with sum function w.r.t columnA, Raw data: ColumnA C...
Custom relative drill link to other Look not opening in dril modal
According to the documentation, using relative links in a LookML link parameter should open the link in a pop-...
Seeking Advice: Running a Chisq_test or T-test in Looker for Conversion Analysis
Hello everyone, I'm new to Looker and I'm interested in conducting a conversion analysis. I would like to perf...
Split comma separated values in column and add it in a new column
I have a table where I created a measure SourceOrderTag which can have 2 values as you can see in the tableThe...
Dynamic number of custom fields per tenant
We have a scenario in which we are multitenant in our warehouse and leverage custom fields in our schema. To b...
Product+Name={{value}} didn't encode comma properly
when I am exploring a dashboard by filtering the dashboard on product name using Product+Name={{value}} in das...
Conditional field display on drilldown
Hi, I have a measure of count for exampleNumber of tests failed Number of tests passedWhen I drill down to tes...
create yes/no dimension after joining
Hi,i have a view that contains a list of products sold lets say view1, with the product dimension containing t...
Postgresql connect error
I tried to connect to a PostgreSQL database. I entered the connection information correctly and opened all the...
Can I create PDT for only few dimensions in the dashboard.
I have a view which uses derived sql. The dashboard is built using this view. The filters takes long time to l...
Blended data for Performance Max campaign in Looker Studio on product level
How to create product level reports that include blended data for Performance Max type of campaigns in Looker ...
How to create quartiler or percentile
Hi,I am trying to replicate the below sql statement in my LookerML file, but returned an error ofSQL compilati...
Dynamic measures based on multiple parameters, MDN Included
Hi, So, a bit of context first:In Table A, I have data with a granularity of one row per observation, with kno...
create measure last year to date in LookML
I’m trying to create a last year measure, I have this: dimension_group: date_orders { type: time timeframes: [...
