How to dynamically calculate an average
Hello, I am trying to dynamically calculate averages. For instance, 3 columns: Detailed level: Row 1: total sa...
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
Case When in Custom Fields Dimension
Hi,How to create Custom Fields Dimension with Case when conditionsi have custom fields dimension and the resul...
System activity explores : adding drill fields
Hi guys - does anyone know if its possible to create Drill fields for System Explore fields?Eg... a dashboard ...
Flag/merge rows with a parameter
Hi, I have the following table for exemple Id Status Uptated_at 123 1 01.10.2021 123 2 02.10.2021 1234 1 1.10....
Marketo - Send list type object from Looker to Marketo
Hello,I’m using Looker to send data to Marketo. Every fields work well, except one, that is a list of invoices...
Getting a Datagroup Trigger Value to use in LookML
This might be a long shot question, but I would like to know if there is any way I can get the trigger value t...
How unpivot a table in LookML?
I have a table with the following structure:month | cost_cat1 | cost_cat2 | cost_cat3But I need this one:month...
Define series_types for pivoted measures meeting criteria?
I have a LookML dashboard file that I want to show bars for monthly values and lines for running totals. I kno...
How to Sort to ascending a date field in a drill Down table
Can We Sort a Drill down Table date field in ascending order.
how to do percentage change on pivoted data
I was trying percentage change measure where I have the date column and the total revenue I pivoted by product...
how to run project
I have do python table,but I don't know how to run the program and test it.
Is it possible to run tests in parallel?
Hi,I have over 130 LookML tests. I can run them on LookML IDE, and they run in series. Therefore, it takes a v...
Best practices for modeling in Snowflake vs LookML?
Hi everyone, I was talking with a former Looker user who asked me the pros and cons of modeling in LookML vs t...
Remove scientific notation for ID fields
Hi, I came across a field that are unique identifiers that have both characters and digits like this: 201220Z0...
Opportunity for Looker Developers
We are looking for multiple LOOKER DEVELOPERS for our startup client. US Candidates from any location may appl...
Opportunity for Looker Developers
Our startup client is looking for Multiple Looker Developers. Role is Remote. US candidates preferred from any...
Looker Developer opportunity
Our startup client is looking for Multiple Looker Developers. Role is Remote. US candidates preferred from any...
How to Avoid Dividing by Zero
When creating percentage measures, it is often useful to make sure you are not dividing by zero in the percent...
verify_remote Fails for Remote Dependency
We have a remote dependency in our Looker project, and when going into Import Credentials to configure the use...
Dynamic dimension based on date filter
Hey guys, I am currently trying to create a dynamic dimension based on the value of a filter. Simple you would...
Time Intelligence & Comparison: best practice for code modularity
Hi,what is the best practice in terms of code modularity for implementing time intelligence & comparison such ...
How to calculate mean over a custom row value something like AVERAGEIF in Excel Spreadsheet?
How do I calculate the average over some values defined in a row ? For example H1 H2 ValueAx || a1 || 1 Ay || ...
Salesforce Extract data from Looker
Does anyone who can help me to connect my Looker platform with CRM Salesforce? Could u please provide me some ...
Derived table SQL: Standardising test to control in Looker dashboard
Hi,I’m building a Looker dashboard and in it I’d like to standardise my test values to control spend (at the m...
Dynamically changing dashboard number in link url
Hello people, I would like to know how to add a dynamic url for to change the dashboard number in a link url i...
LookML - filter measure by the dimension in another view
Context:View 1: Fact Sales Dimension: Date Measure: Total Sales View 2: Dim Calendar Dimension: Date Year Ques...
Dashboard Filters
I am trying to put filter on my dashboard but the suggestionsare not populating, please suggest.
Transform a number into hour and minute
Good afternoon, I need some help. I need to transform a dimension I created from a datediff into an Hour and M...
Software for academic course
would like info about academic program from Looker [eg. software provided to teach a BI course ..]
