Dynamic Timeframe option
I need to create a custom option in the timeframes drop down menu that will vary depending on the user. For ex...
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
Dashboard Button link to get filter values and auto-apply in Look
Could you help me with one tricky functionality I am trying to implement in Looker.Let me provide the backgrou...
Looker Over Complex Queries
Hi, I'm having an issue right now in looker where I have an explore based on one table let's just call it "amo...
Liquid: number_with_delimiter not working
Hi, am new to Looker and I am trying to use liquid for some advanced conditional formating but it seems to me ...
Uniqueness test generates wrong SQL with count(distinct)
I have a model, where videos is main table, with playbacks joined to it. Each playback has playback_key (set a...
Difficulty Formatting Percentage Values in Looker Visualizations
Hello,I'm encountering an issue with percentage formatting in Looker visualizations. I have defined a measure ...
How to convert number to time in looker
Hello Team,I am query regarding how to convert measure with number data type to time data type in the form of ...
Google Looker actions
I'm attempting to create a dimension based on the value generated by a HTTP request. After some research, it s...
liquid with drill_fields
Hi, Im trying to achieve something along the lines of the following. I want to display a different set of deta...
New LookML breaks cell HTML colour format
Problem: in 19 days, a Looker upgrade will be performed in my instance, and the HTML/Liquid rendering for heat...
Download PDF reports limits the rows
When downloading a report as .pdf, we select download and it does download only what’s visible in the UI. it d...
Required Dimension in Explore
I’m building an explore that will be used for a very specific purpose, and because of this there are certain d...
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...
Is it possible to have multiple select option for Parameter filter in dynamic measures
I want to know if there is a way to multi select revenue and order count at the same time and see data.Sample ...
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
percent_of_total Question
From the docs: “percent_of_total calculates a cell’s portion of the column total. The percentage is calculated...
Is it possible to rename fields when joining a view to a explore?
I would want to rename a field when doing the join of a view into a explore, to have a more descriptive name f...
Is there a way to view LookML Dashboard usage?
Anyone know if there is a way to track usage/views/queries of LookML dashboards either directly or indirectly?...
Displaying null values in sums
Looker Coalesces by Default By default, Looker coalesces sum measures with zero. This gives us a nice “0” disp...
Slider Parameter
HI there,I am trying to create a slider style parameter. So in the slider I need a range of values, say 0 to 1...
Currency Conversion Parameter and Formatting
It’s common to want to switch between currencies in Looker. This is usually achieved by having your results/ta...
How to convert time duration(Ex.. like 1d 5h 12m 25s from 55678900 seconds )
Hi,i am a looker developer i need to create one look.i have a dimension called duration,dimension: duration{ty...
Order of displayed filters
Is there a way to specify the order of the filters displayed in dashboards?Ex: I have a filter on countries. A...
How to display text string with html tags as html
I have a simple string dimension that contains html tags. When I display in Looker it treats the dimension as ...
Connected Sheets for Looker limitations: always_on_filters, drill_fields
Hi, I am trying out Connected Sheets for Looker, so accessing LookML explore via Google Sheets and I am seeing...
Aggregate Awareness with Templated Filters or Parameters
I'm looking to leverage Aggregate Awareness for our large tables. Our BigQuery database is partitioned by date...
Dynamically call constant
Hey guys, does anyone know if it is possible to dynamically call a constant based on one parameter the user se...
Looker Table Calculation to get rendered value of a column
Hello Team,I'm seeking guidance on a specific aspect of LookML related to a measure I'm working on. My goal is...
