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_...
Forum Posts
Dynamic Parameter for Dashboard Tile?
I am trying to build a tile for a dashboard that inherits a region dimension from the filter.Basically, the ti...
Templated filter to get the max date in Looker Look ML
Dear All,Would like to hear your thoughts on one of the requirements we're attempting to do in Looker.Sales an...
Field Names on X-Axis (Line Chart)
Hi there! I'm returning to Looker after a few years for a project and I'm stuck on getting it to format this c...
Using Liquid to dynamically adjust dimension definition of a derived table.
My situation is roughly as follows: I have a base view that contains daily pre-aggregated data with several at...
Dynamically adjusting connection based on user attributes
Hi! I'm working on a project to move our looker workloads from SQL Server to Snowflake. I'd like to be able to...
Select fields dynamically from a filter to use in a dashboard visual
I am trying to add fields (more than one) dynamically from a filter (which has a list of fields defined as a m...
Custom preset for a dashboard filter
I want to have a predefined collection of custom filter values for a dashboard. Something like configure defau...
connected model to another model
Is it possible to have one model which is connected to an other model ? I've my modelA which is connected to B...
Column has [object Object] values instead of dates
Hello! I'm trying to convert a string column to a date. (We use Trino for querying the data in Looker)The date...
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...
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 ...
Not able to see the filters in Explore in Edit Mode
I have a dashboard, In which i have 4 looks. I was asked to apply a date filter on it. When I added, it worked...
Filtering records based on a user specified date that falls between start date and end date fields
Without creating a derived table, is there a way to filter records in Lookml based on a user-specified date wh...
Not able to see the views on Explore
Hi All, I have 2 views. When i go to looker -> develop -> then these views are visible to me. But, when I go t...
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...
Filter Max Date by different timeframes
Hi! I have an unusual use case that i would like to resolve. I have a BigQuery table that has information week...
Filter last n months
If the current date is April 9, 2024, which days in the past 3 months will it retrieve data?I dont see documen...
How to PoP
https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Methods-for-Period-Over-Period-PoP-Analysis-in-L...
Pull Field Labels & Descriptions from separate tiny table?
Long story short.Have a survey with many questions - say 20.Each question is a column - I know it can be done ...
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...
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...
Collapsible Text or Markdown
I'm trying to make my dashboards cleaner. Currently we have descriptions that are important for users that are...
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...
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...
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...
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...
Looker
format_datetime('%b-%y',current_date()) how write above one in liquid parameters
Link a Dashboard to another one passing values
Hi all!I have a dashboard with some information on a grid (Project info); my goal is to click on a value in a ...