percentage of subtotals
Hello,I would like to calculate the percentage of Rev for each age group compared to its Brand (subtotal)Thank...
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
A (Hitchhiker's) Guide to Query Performance in Looker
Problem: You’ve written alot of very nice LookML, but your data is >20TB and queries take forever. This isn’t ...
difference between dates and grouping the results by another dimension
can someone help me with how to find the difference between 2 dates? date_diff() or diff_days() is not working...
Snowflake database encountered an error - unexpected "as"
I tried to get the 2 dimensions order ID and the date and SQL automatically adds another LIMIT clause in betwe...
How do you group by billing cycle month dates (e.g. 2021-03-03 to 2021-04-03) instead of calendar dates?
I am creating a report of number of transactions in the past nmonths group by billing cycle months instead of ...
Liquid HTML - Format to 2 decimals
We are using {{value|round:2}} to round decimal points, but we need to add 0s to transform values like “3.0” t...
format date
I need to convert a date that is in the format yyyy-mm-dd hh: mm: ss to dd-mm-yyyy hh: mm: ss, but all the fun...
Day of week
I want to create a measure which shows the number of business days between 2 specified dates. The problem Im f...
How to avoid unnecessary join
Hi, I have an explore in which I join a view, say view1 to another view, say view2 like so:explore: view1{ joi...
HTML reference to a dummy dimension
Hello, I have two following dimensions: dimension_group: date_attribution { type: time timeframes: [ raw, date...
Table Calculations: Different Value Format for Each Row
Hello,I have implemented the table transpose solution described here. However, in the example by Looker, all t...
Is it possible to use the new Looker Components in a views HTML parameter?
Pretty much what the title is asking. Could you measure: field_1 { type: count HTML: Inform (default) {{ field...
Not able to Connect CSV file to a Looker trail version
I am trying to create a New model and import CSV file in the development mode of Looker trail version. How do ...
Can't create projects
Hello everyone, why can’t I create new projects ?I’ve seen in the documentation that, in Development Mode, sho...
Question Regarding working with a dynamic dimension
Hi there,I have been trying to figure out how to calculate and group values of a dynamic dimension. Here is th...
Commit Button not Showing
My commit button is not showing although I am in developer mode and the git panel shows on the left side of th...
Filter using two sets of dates
I am currently working on a loss ratio report that aggregates our clients invoice amounts and claim expenditur...
SQL windowing functions in looker
I’m sure this question has been asked more than once in the past - but is there any plans to incorporate windo...
Scheduled task building PDT even though the PDT build trigger conditions were not met.
Hi Experts, We are experiencing an issue where some scheduled tasks are triggering PDT build event, even thoug...
After Looker last update my table totals wont pick up format from visulization
Good Morning,Last Wednesday there was an update to our Looker that caused us all kinds of problems. The big on...
How to rank dates per unique ID in a table?
Please see attachment,Currently I am having to export the data in excel to do this work. I would love to see i...
Using extensions to define joins
When modeling, joins can be redefined in different explores. For example, wherever we join users, we will join...
How to ignore null dimension value results
Hi, My use case is as follows:I am setting up an explore for a table in bigquery whose schema looks like below...
Optimizing Base Model
I am currently building my base model by joining views in an Explore and extending. Since Looker has to write ...
Creating a PDT on the fly?
I recently discovered a PDT can be created on the fly either using a WITH statement or using Liquid. Right now...
API driven updates to LKML files
Hi,I am currently facing a scenario where the lkml model/view files can be frequently updated (schema can chan...
what are the types can be assigned to constant in the manifest file?
Hi,I saw on the documentation that there is an option to assign constant values to variable with “constant”.In...
Big Query Error Message
Hello! I’m trying to submit the query below in BigQuerySELECTuser_id,advertiser_id,lineitem_id,creative_id,cou...
Duration (In Hours) Excluding Weekends
Hi Community, Wanting to pick your brain on a way to do a duration between two Timestamps, but excluding weeke...
Sum sales between start and en date
Hi all, hope you’re doing great.ContextI would like to find a way to calculate Purchase Offline KPI.This KPI i...
