Am I able to use liquid filters to determine the value of the 'hidden: ' field ?
I would like to use something like this so that I’m able to hide dimensions based on the name of the view. dim...
Forum Posts
Comparing Dates with Liquid
Usually, if we have a case in which we need to compare dates within Looker , we do that using SQL (like filter...
Pass date filter using liquid variables in html
Hello… hoping you can advise. I’m trying to pass multiple dashboard filters including a “date range” filter to...
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...
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...
Charts like Stock Market
Hi,I am trying to create a chart that looks similar to a stock market chart , that gives you the value of a st...
Liquid - Number format
Hey everyone, nice to meet you all.I have a measure, which has several ifs, as it follows:measure: someMeasure...
Dynamic derived table based on filter
Hi Looker expert, I wonder if there is way to access the filter value inside the derived table sql statement? ...
Implement vertical "writing-mode" in Looker "Table" visualisation
Hi,I wonder any expert out here can help me please.I have a tabular report in Looker that has one pivoted dime...
Looping over a list of Dimensions
So I have the following code using a combination of good ol LookML and Liquid. What I am trying to do is loop ...
Shared filters/parameters between multiple views used in one visual
Hello,we have two views on two different fact tables joined inside one explore (not the same granularity and d...
Liquid _in_query not working for custom dimensions
Hi!I have a set of derived tables where I use Liquid to include/exclude columns in the SELECT statement based ...
Creating two parameters, one dependent on the other
I am trying to create two parameters, one the selects the date granularity and then based off this, one that a...
Product+Name={{value}} didn't encode comma properly
when I am exploring a dashboard by filtering the dashboard on product name using Product+Name={{value}} in das...
Dynamic measures based on multiple parameters, MDN Included
Hi, So, a bit of context first:In Table A, I have data with a granularity of one row per observation, with kno...
Dependent Looker filter depending on user selection in dashboard filter
There is a dashboard filter with 4 user input selections. Based on what user selects there I want to be able t...
Need to create a field that returns a Yes/No based on timeframe chosen by user
I have a table of Tasks with the description/info of the task as well as that date it was created.What I need ...
Partition pruning from looker filters based on labels
Hi,we have bigquery table as source for our view/explore.This table has (to simplify) columns:REGION_NAME, REG...
count lookml with user input filter
hi, i have created a measure with count and i have 2 questions:on which granularity is the count performed? i ...
Dynamic Measure Not Working
I’m trying to create a report where users can view the Revenue by month OR the Clicks by month. I think Dynami...
Point to one or another table based on date filter
Hi!I have two tables on BQ, one table has the historical information (= 2022).I’m trying to create a Liquid se...
One Button Solution - Period over Period Analysis with a Set Trend for each Date Type
Hi!What I currently have is the following:A “to date filter”, that filters yesterday, weekly, monthly, quarter...
mesure distribution in month table (active users)
Hello guys, I have a measure that counts employees actively working in a range of time, so the measure looks a...
How to set up an aggregation year filter and switch the data acquisition year for the entire dashboard at once
We would like to know if you have any ideas on how to implement the requirements in the following prerequisite...
Load filter suggestions for dynamic sql_table_name
Hello All,I have a scenario where I need to pick a database/schema for a table based on a user selectionbelow ...
render html markup of words inside text
I am trying to apply html markup to individual words in a sentence. The behavior I want works on individual re...
can we liquid if else with templated filters instead of case when
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
Can we use liquid parameters in string filter field to assign dimension values to be used as dynamic filters
Hello,I came across one use case where I had to assign multiple filters based on a specific value of a dimensi...
Dynamic Parameter Values
Hello all,I was just wondering if the future versions of looker are going to support dynamic parameter values....
Is it possible for an Explore to join a view which includes a liquid variable to itself?
I have a user_history table with roughly 100 fields, in which each record has a start_date and end_date. I’d l...