Default Visualization for Quickstart
Hello,I’m attempting to create a quickstart that’s simple for my looker users. When I click on that quick star...
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
How do I give a user access to a specific explore?
Hi,So I am a LookML developer and Im not that good yet with access. We have a lot of different explores which ...
How to PoP
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Methods-for-Period-Over-Period-PoP-Analysis-in-L...
Pull Field Labels & Descriptions from separate tiny table?
Long story short.Have a survey with many questions - say 20.Each question is a column - I know it can be done ...
Symmetric aggregates overflow bug?
Here is some lookml : view: debug_test_1 { derived_table: { sql: SELECT '14d' as id UNION ALL SELECT '13d' as ...
Dynamically apply calculation to all table values
Hi everyone!Little stuck on on something…Image that there is a table with one dimension with a bunch of measur...
Dividing between two values in a table
Hello,I have a table with two columns (with data pulled from Google Analytics): event action and total events....
Inaccessible view despite views being joined in explore
Hi, I have created a new dimension "dimension_one" in my view "view_one". This new dimension references fields...
Change looker Default time zone to EST
Hi,I am looking to add a filter on date: Idea is to get real time orders from order table (local time is EST)M...
Only measuring the "latest" values
What’s in a measure? All too often, we limit ourselves needlessly when we equate measures, metrics, or aggrega...
Configuring a dynamic explore_source in Native Derived Table?
I’m trying to make a generic view to allow “Top N” rankings on pivotted Looks (eg. line-chart timeseries). I’v...
Is it possible to assign date_start to a liquid variable
Please see my reply comment left in this thread . I am basically trying to do exactly what OP did by using liq...
Comparing Dates with Liquid
Usually, if we have a case in which we need to compare dates within Looker , we do that using SQL (like filter...
Creating a dimension % of a total
I have categories of revenue loss as dimensions per month with their monthly value, and I need to calculate th...
Collapsible Text or Markdown
I'm trying to make my dashboards cleaner. Currently we have descriptions that are important for users that are...
File Browser / Resize
Our data sources in the file browser are very long, therefore we need often to scroll the bar.Currently the si...
Show multiple lines in line chart
I have the data like this-date| product| priceI want to plot the prices of the products datewise on a linechar...
LookML error: could not find a field 'nbfc_name'
Here is the code snippet. I m unable to figure out why it throws this error even when the field is present. vi...
User Attribute in Manifest
Does anybody know if it is possible to use an user attribute in the manifest of a project? I need to use the u...
Bigquery and Looker tables not synched
Recent modifications were made to our google bigquery tables but I don't see the modifications in my looker ta...
Location Calculation without Studio or LookML
Is there a way to calculate distance between two points without Studio or LookML, just an expression generated...
Facebook Ads from Fivetran
Hi. I just discovered the Facebook Ads block in Marketplace, and wanted to try it out by setting up the Fivetr...
Crazy average value on measure
Looker is generating a crazy average SQL and I don't understand why. In my view, I have a number field which r...
Comparison table in ga4
I want to create a table in looker similar to the comparison table in ga4, but I don't know exactly how. If th...
Dynamically changing looker connection inside model file
I have been trying to dynamically change the looker connection using user attributes. Here the database connec...
Refinement
im having problem with my Refinement view.if explore using my view sit in different model then it will use the...
Conversions count error
Looker Studio is connected to Analytics 4 property. Looker Studio dashboard shows all data except data for Con...
i Want to manipulate "period Control" filter in my looker studio
I have a report and need to be able to manipulate the value of the "Date Range Control" field. I need to get s...
Best Practices for Connecting Looker to Data Warehouse?
Did you all use data engineers to create the pipelines, or did you use a dedicated reverse ETL platform like C...
Table calculation (division) is showing a wrong result
Hi Looker team,I’ve set up a metric in Looker Studio called ROI = (x - y) / yThe result is wrong, i.e. In the ...
