Subtotals depending on columns
Hi, I want to create subtotals calculated depending on the user selection - based on 4 columns. Any idea how I...
Forum Posts
Problem in Complex Calculation for SD
Hi All, I am trying to create a Calculated field in Looker Studio but every-time i am trying it i am getting a...
Dynamic Dashboard Filter Help
Hi all,I am trying to figure out how to create some sort of dynamic filter for a dashboard I am creating. The ...
Create buckets to pivot by
Hello! I have data regarding scores in four different tests (A,B,C,D) & I would like to be able to track the d...
Summing values of a dimension based on criteria of another dimension
Hi all,I have been stuck on this for longer than I would like. I have a table with various dimensions. One dim...
How to default date filter to maximum date in dataset?
For context, we have a campaign that sends an email out once a month. On the dashboard I created to analyse th...
Mandatory Filter
Hi, I want to use column Country as a filter for the Dashboard like this: every time a user opens the dashboar...
Dashboard migration which having link parameter
Can Someone guide me on this ?I have 2 dashboards , one is linked with another using link parameter . When I c...
Feature Request - Time Conversion
I just noticed this great feature on Stripe and I think it would be invaluable addition to Looker if we could ...
filtered not
I’m trying to make work this kind of condition :NOT({% condition has_not_property %} property {% endcondition ...
What the max size has GCP Persistent disk?
What the max size has GCP Persistent disk?
Explorer for wrong references. Best practice
I have 2 viewsOrders.view derived_table: { sql: select 1 as id, 100 as amount, 1 as customer_id UNION ALL sele...
Is there a way to make a dashboard filter default to "contains" instead of "Is"?
as of now, this can only be done in a look but how can you do this in a dashboard?
Cannot find Import project to develop looks
I imported a remote project into an instance, added new views and an explore and pushed to production. I canno...
Can I create an alert that only sends an email when number of survey responses increase?
Hi, I am struggling with creating an alert that sends and email ONLY when my number of survey responses increa...
Last date in a table
Hello everyone, I have a question about the data type: date in Looker.I need to show the last date where a pro...
(LOD) Make Measure Value Fixed Regardless of Dimension in the Visual
Hello, I want to share my knowledge regarding Level of Detail (LOD) - Fixed as in the features in Tableau.Here...
How to dynamically change the unit of time in the look, based on the time filter selected by the user?
Hi,Let’s assume a very simple case- one date filter on the dashboard and one look with “Order Month” on its x ...
Need Help with grouping range of days in a week
So I was ask get the weekly data score of each team we have, but in each week only Sun - Thurs data shall be c...
How to use parameters values to two different Looks
Hi All,Is it possible to toggle two different Looks on a Looker Dashboard. Scenario - I have two parameters ca...
Last 24 hours
Hey Everyone, I am getting live data ,every minute data getting updated. I want to show some reporting numbers...
Limit dropdown options of type: field_filter using LookML codes
Hi, I would like to know how can I change my default drop down for the filter Control : Advanced. There is a c...
Calculated column aggregation
Hello experts!I made a calculated field with if( some column <5, "NB", "B") and would like to see aggregated r...
Value Labels in graphs showing in different format
Hello,I created a value format to simplify large numbers, but i needed to use localization so i used HTML as w...
Looker Alert Trigger Time Frame
Hi All. If I set alert frequency as daily at 5am, does it mean that alert will only be triggered if condition ...
Aggregating rows
Hello everyone,I’m reaching out for some help on how to aggregate rows in order to correctly display them in a...
Dynamically adjust min max Y axis value
I wanted a graph to have a minimum value for the Y-axis. I know it can be set manually. But is there a way to ...
Could not find the model or view requested when Development mode turned on
Hi, Im able to see the explore when i turn the Development mode off, but when i turn on the Development mode o...
post merge query aggregation
Hello. I merged two queries with date, ID1and ID2. Now, I hide the ID1 and ID2 from visualization and I want t...
How to create star rating from numeric value using HTML and Liquid
Hi fellow Lookers,In this post, I want to share my solution and highlight some issues when creating a star rat...