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...
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
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: [...
Can users define group by clause in explore?
Hi, I want to create the following query in looker:SELECT _______, COUNT(*)FROM MEMBERGROUP BY _____In the cod...
Frequently have to reset GIT connection
All of my production projects have lost their GIT connection, however none of my Stage projects have even thou...
Views with more than 1 view mentioned in dimensions/measures
Hi,With the introduction of 23.6 we’ve encountered an issue with something @lloyd_tabb suggested in 2015- bare...
Cannot extend an explore joined to a view which uses bind_all_filters
Here’s the problem I’m running into. I have a view that uses bind_all_filters and looks like this:view: top_cu...
Not able to connect a custom query of my sql which is with dynamic filters and running fine in my sql server redash
Not able to connect a custom query of my sql which is with dynamic filters and running fine in my sql server r...
hamburger menu button in looker dashboard/view
Can we create hamburger menu button in looker dashboard/view ?
How to add conditional format for NULL (∅) values in LOOKML
Hi,I’m able to apply conditional format for empty values but I could not able to apply the conditional format ...
