Text Wrapping / Fully Qualified Naming on send/schedule view
Hello! Is there any way to either wrap the text or just display the field name in the send/schedule filtering ...
Forum Posts
How to implement DatesYTD and DatesMTD using LookML
Implementation of DatesYTD, DatesMTD using LookML is simple, you just have to create another explore with sql_...
case when condition for replacing null value to string and non-null values to keep it as same.
Hi team,I am trying to execute the below condition which is if the column has null values (∅) symbol, I want t...
How to create a measure in LookML based on different views/explorers
I have created two views from a table with some implemented measures. It's something basic, illustrated as fol...
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...
Difficulty Formatting Percentage Values in Looker Visualizations
Hello,I'm encountering an issue with percentage formatting in Looker visualizations. I have defined a measure ...
I am looking to create a Calendar
i wanna create a calendar con i can visualize the time off of my employees, is it posible on looker?in a calen...
Which would be the best 3D modelling software available in the market?
I am currently pursuing Robotics Engg. I had question in my mind that, which would be the best 3D modeling sof...
How to determine when Query Performance issues are caused by Database Bottlenecks/Settings?
There are many factors that contribute to slow Query Performance in the Looker application, one of the most co...
Manage auto refresh for a report doesnt work
I use Google Analytics Pro and I can't find the auto refresh featureIt does not exist under recourse
Best practises for Total metrics in datasets
Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.I have a dataset that ...
Want to use filter value in liquid IF in dimension SQL field
I want to access the value of a filter on a dimension inside a liquid IF statement in a measure SQL line.I kno...
join views by running agreggations in each view separately before final join
Hello, I would love to speed up some looker dashboards by updating our data models. Here is how data looks lik...
Best practice to set up data to aggregate over rolling 1d, 7d, and 28d time periods
Hi all! I have a table with a set of user_ids and various activities/boolean values for them. We want to be ab...
idiom problems
im triying to make a report and im working in english but when my boss uploaded the report in our page (where ...
One Measure as pivot data one measure as Unpivot( single) data
view: my_view {measure: revenue {type: sumsql: ${TABLE}.revenue ;;}dimension: category {type: stringsql: ${TAB...
Persist Data and Auto-Refresh
I have some slow running models and have found adding `persist_for` for 1440 minutes and scheduling the dashbo...
Using constants to define allowed values in a parameter
Hi,I have a use case where I need to use the same parameter, containing multiple allowed values, across multip...
Dimension to Handle Array Type data in Lookml
Hi,I have a table >500B rows. DBA has put a rule that the table can only be queried with a where condition on ...
Rebuilding only a portion of PTD
Hi all,Is it possible to rebuild only a portion of a PDT based on a key? What I need is different from an incr...
Data Lineage for derived table
Hi! I'd like to visually check the connection structure of the derived table(and also Persistent derived tabl...
find the max NPS partitioned by property
I am currently working on a project where I calculate the NPS for different properties using Looker. I have be...
Using the BQ Info Schema Block
The BigQuery Information Schema block has, broadly, two main uses: monitoring and optimization. This article w...
View Usage
Hello!I wonder if there is any way to check if a view is being used and where it is being used. I'm rebuilding...
How to: Tuning your Looker Project for speed using only your Model file.
This post will explain how you can begin to optimize your Looker instance by tuning your Model file (no view-l...
How to filter a data in graphs and table
Hi AllI have more than 1000 products in my data. How can I filter just one product in graph for spesific perio...
New field shows wrong values
I need to create a new field which shows only the users that reached a specific landing page of a website, wit...
GA4 to Looker data lag
I have a simple dashboard which includes graphs for purchase revenue and session medium.This is set to be the ...
GA4 Source/medium breakdown
On GA4 under the traffic acquisition report you can change the dimension to source/medium, however in Looker t...
Site CTR from GSC
Hiya!I'm trying to modify a Looker report (https://www.metricized.com/looker-studio-templates/search-console) ...