Symmetric aggregates overflow bug?
Here is some lookml : view: debug_test_1 { derived_table: { sql: SELECT '14d' as id UNION ALL SELECT '13d' as ...
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
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 ...
LookML concatenation with space in between fields
Trying to concatenate dimensions and separate them with a space or dash but when I add in the character the ne...
templates for looker studio
Hi, i hope you are well. Does anyone know if there is a website where I can get nice looker templates for ga4 ...
dimension_group Automatic Label Suffix
Using a dimension_group of type time, Looker automatically appends “Date” to the label. For example, given the...
Error: Creating an NDT with bind_all_filters on an explore which is extended
Hi all,We need to create a dynamic top N ranking on a dimension and we feel like creating an NDT with bind_all...
