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...
Forum Posts
Set default value on lookml dashboard using another filter (and its associated parameter)
I was wondering if it was possible to create a filter based on a parameter and have the parameters value be an...
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 number of custom fields per tenant
We have a scenario in which we are multitenant in our warehouse and leverage custom fields in our schema. To b...
how to make text box dynamic
I have a dimension product_name, and my requirement is that in dashboard I want to show user with the text: “H...
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...
Dynamic dates based on Completed period and period to date
Hi all, I was wondering if anyone has set up / knows how to do dynamic dates that are able to filter for day l...
Creating a dynamic URL that links to different dashboard
I’m trying to link two dashboards together because it seems like looker doesn’t support dashboards having sepa...
Create matrix using a dimension containing the names of several measures and display their values conditionally row by row into a dummy measure
I am trying to create a table in which I display the measures names in rows while bringing their respective va...
Passing column names from a query result into new query
I want to query a table that have over 2k columns and its constantly increase the number of columns. We want t...
How to select columns dynamically in a filter
I have a existing report which needs to migrate into looker in which one filter values are having the column n...
Strange warnings when using constants in Dashboard LookML
Hi community! I’m working on a project using the SA 360 looker block and I’m trying to use constants to make t...
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...
Dynamically changing dashboard number in link url
Hello people, I would like to know how to add a dynamic url for to change the dashboard number in a link url i...
How do I set a liquid parameter based on a dashboard filter?
Hi all,I have a LookML dashboard with a filter for two looks- dashboard: overview filters: - name: time_spec t...
Issue Staging Data Dynamically
We have a large base_table in our Snowflake database that contains row-by-row transactions from all of our sub...
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...