How to Create Dynamic Dimension Filter
Hi,New to dynamic dimensions and measures and am having trouble solving my problem after following the other g...
Forum Posts
Using IF ELSE with 2 parameter
Need help! I’ve been trying different IF ELSE logic combination to achieve the results. here’s my sample query...
Error referencing parameter of a different view
I have a view_A and a view_B which contains a derived table. I am trying to reference a 'timeframe picker' par...
Liquid Parameters - Output inside IF block
Finally got some time to spend on Liquid and I have this use case, mostly to reduce the SQL.Right now I have t...
"Must provide a field name for parameter" error message
Hi, I’m trying to create a simple parameter to choose between 2 dimensions to breakdown a view. I’ve copied th...
Create a custom filter based on new options
Hi there,In tableau you can create sets from values, and then use those sets to define a new list of options f...
Unexpected ELSE in parameter
I have the following parameter code block: set: absolute { fields: [ 10th_percentile, 25th_percentile, 50th_pe...
Calculations on whole dashboard using LookML
I would like to create a parameter in LookML which normalises all the metrics on a dashboard when selected. So...
Parameter to select set of metrics or do a calculation on multiple dimensions
I have a set of metrics that I want to visualise on a dashboard or exploreI would like to have some way of eit...
Can tables within the same schema become a filter?
There are many tables in our database having the same structure, and all of them need to add some customized m...
The filter "Xxxx" is not allowed when using liquid parameter in dynamic derived tables
Hello,I have a problem, I am trying to dynamically query column from the database, I wish to create a paramete...
Dynamic named_value_Format
is there anyway to make this code work from this thread: https://community.looker.com/lookml-5/dynamic-value-f...
Date Parameter In a LookML View
I have a LookML that is powered by a big query view where the dataset that I am pulling from is partitioned on...
How can we automatically populate a parameter allowed values from another view dimension ?
Hello, is there a way to populate a parameter allowed values from the result of an sql query against another v...
Dynamic Forecasted Measures
Scenario Predictive analytics and machine learning have been popular buzzwords as of late and can provide trem...
Using order_by_field with dynamic dimensions using parameters
I defined a dynamic dimension that I use as filter, as described examples here and here.For example one option...
Is it possible to return dimensions with different types under a single parameter?
Hi all, Now I have the data which is similar as follows:week_from_launch date sales 52 2020-08-15 1000104 2021...
Having issues to pass filter on partition filter as argument to derived sql in LookML
Hi,I have a hive table with datestamp as partition in 'YYYYMMDD' format. I am trying to design a view with a d...
The updated Period-over-Period Guide by Montreal Analytics
Hello Looker folks!The team @ Montreal Analytics has updated our popular Period-over-Period block!You can find...
Parameters - Unexpected behaviour
Hi all,I’m using a Parameter that I pass into a Dynamic Measure and into an HTML field that I use as a separat...
Rank Calculation Issue
I have created Rank using SQL derived table, would like to know how can i make it dynamic.Issue I am facing is...
Dynamic value in parameter
Hello All,I want to create a dynamic parameter where I can choose the next three months from current month.Can...
how to escape a special character in my dynamic URL
Hello , I’m having an issue in which I have a parameter in my URL , for the most part it works well except one...
Using liquid parameters in SQL breaks filter suggestions
Hello,I am writing custom SQL to define my table in Looker and I’m trying to filter date within the look using...
Metric Selector Parameter as column
I would like to create a list of metrics as a dimension so I can create the following. I would then need to fi...
How to get Filter's Start and End Date From Another View?
Hi guys, hope you are doing great. I would like to know if anyone can help me with my problem, but first, I wa...
Liquid syntax
Hello everyone,I can’t understand why the following block of code works(First Block) while the one below(Secon...
Using measures multiple times based on parameters
Hi!Is there a way to repeat measures (or dimensions) multiple times depending on parameters?To set up the cont...
Concatenate strings in liquid if statement for label
I am trying to concatenate strings inside a liquid if statement as part of the label argument of a dimension b...
Restricting date parameter values
If I have two parameters parameter: reference_period { type: date } parameter: compared_period { type: date }i...