Date Parameter Default Setting to yesterday
Hi there,I’m quite new to Looker (a few weeks now) and got stuck at a Parameter default topic.The parameter is...
Forum Posts
Dynamically apply calculation to all table values
Hi everyone!Little stuck on on something…Image that there is a table with one dimension with a bunch of measur...
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...
Filter Suggest Dimension from Liquid Parameter
Hi All,I am creating a dynamic comparison tool which allows users to select a granularity to compare a selecti...
Parameter in sql table name
I am trying to parameterise my connection:view: view_name { sql_table_name: {% parameter tablename %};; parame...
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...
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...
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...
Can users define group by clause in explore?
Hi, I want to create the following query in looker:SELECT _______, COUNT(*)FROM MEMBERGROUP BY _____In the cod...
Switch between two measures defined in two different views
Hello,I would like to give the users of my dashboard the opportunity to switch between two different measures ...
Is it possible to extend two views and use a LookML parameter in the extended view?
I have two views:country.view view: country { sql_table_name: my_project.my_dataset.country_table ;; dimension...
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...
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 ...
Parametrised values not working as expected
Hi,I’m trying to use parameters to switch between different columns in a visualisation. So the user can select...
Dynamic Parameter Values
Hello all,I was just wondering if the future versions of looker are going to support dynamic parameter values....
I want to calculate top reduced business compared with week/month
Hi team,I want to calculate the change revenue week/month and list all businesses with big change about sales
How to set a relative date as the default date for a date filter parameter?
How to set default value for a date filter parameter which is like ‘3 months before todays date’ and also give...
Custom filter on measure
I have created a parameter using allowed values and a certain range of percentages to select: parameter: param...
Set parameter value in a different view
Hello! I have a view that has a parameter. It is structured just like thisview: table_1 { derived_table: { sql...
How to update case statement in join to use aliasing instead?
I have a report that’s running off an Explore in my model, but one of the joins to a view needs to be updated ...
user selected value in query as filter
I am trying to create a derived table based off the below query on Looker. Except, I want the user to choose t...
Why would anyone put a test in a View?
According to the documentation here, tests can be placed into a View file but this seems counter-intuitive to ...
Accessing View date_time parameter from Explore
Hi there,If I'm looking to add in a date criteria to the sql_on parameter in an Explore join, am I able to lev...
Custom filters/parameters: Select a complete full month
Hello,I have created a dashboard where I want the users to be able to compare period over period, specifically...
How can I use special character in Liquid Filter?
SITUATIONI have parameter and filter and this is the LOOKML:parameter: attr { type: unquoted description: "Nam...
Add weekend to a time_period parameter
Hey Guys,I have a time_period parameter that has values for Day, Week, Month, Fiscal Month. Can anyone suggest...
Reassign parameter value in LookML
How can I reassign the parameter value by selected value in filter?What I tried to do:{% assign var=_filters[‘...
Add multiple filter condition in paramater
Currently this User 1 Filter 1 Num Val filter is equating the exact value of what ever the user input in the v...
Empty map drill overlay modal displaying only proper drill-fields for location-type dimensions
In case anyone else is struggling with this issue, I did not see another thread or any documentation of this e...