Table calculation's value based on other calculation
I discovered a very weird behaviour and not sure if it’s just me. The first calculation is just offset(${measu...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
? with tooltip on dashboard tile title
The dashboard tile titles at foo.looker.com/admin/instance_performance_dashboard are preceded by a circled que...
Edit Custom Measure doesn't select a measure
I created a Custom Dimension with simple diff_days() and then clicked and selected Average, which created a me...
Setting Up Alerts on Table Calculations that are based on other Table Calculations
When I set up an alert based on the table calculation shown below, the alert does not get triggered. Is it bec...
Filter on "Month" is actually filter on "Date"
Anyone else got confused by this? I used “type: date_month” in Lookml to generate the month. But I just notice...
Connecting Googlesheet(Source) to Looker(target)
Hi, I am exploring on Looker and I want to create Looker dashboard using Google sheet. ( Google sheet as input...
Filter is applied to Tile after edit even if switched off from filters
I have a dashboard with bunch of single value tiles that are connected to a city filter. Then I have a column ...
Choose field based on the extract_months(now())
Hi everyone. I am looking to build a table calculation that chooses a field (sum of fields in this case) based...
Mixed type visualisation - can't change settings for each series
If I use two series one as Column Bar and one as Line, I’m losing ability to change particular type’s settings...
Hide Value Labels from a calculated Measure
Hi, Community! I have my first question, hopefully we can sort it out together. I have my daily sales and I ha...
Pivot_where returns error with custom dimension but still works
When creating a Table Calculation that uses Custom Dimension in expression, it shows an error but it’s a false...
Conditional value format
Hi, I have an amount column which should be positive for some transaction types and negative for some other tr...
Drill to explicit LookML dashboard without enabling lab feature?
Hi there, I’m trying to figure out how I might enable my users to drill to a specific LookML dashboard from a ...
creating a combinationtable to explore customer buying behaviour.
Hello. I have a set of customers, and the products they have bought. I want to do a vizualisation exploring th...
Getting all Denodo view info from Model explorer
Hi, Could someone help me to list out a specific data source (like Denodo) objects from Looker? Suppose I have...
Custom filter - Logged in after a specific date
I’m trying to apply a custom filter to see all customers who logged in after a certain date but struggling to ...
'Cancel' on Edit Filters on dashboard still saves changes
Hi, Just wondering if anyone has experienced this and/or if this is a bug. I have noticed that if I make chang...
Discussion: Exploring explores ?
Hey everyone, just wanted to discuss something that I have had in my mind for a while. What would you think if...
How to sum the values of a column based on value in another column
Hi, I have a column named project name and another column named allocation % I want to sum up the allocations ...
Filtering out duplicate values — where is my "count_distinct" function?
I’m looking for a way to “count_distinct” values that are not a visible/selected dimension in my look. The fun...
Dimension for Table Calculation Subtotals
I am trying to create a bar chart. I have two dimensions, one is a parent (this is the dimension I’d like in t...
How to filter a measure but still show totals
There are some cases where you only want to see rows where a measure returns above a certain value, but you st...
How to adjust the date/timestamp filter in Dashboard
Hi, I am trying to display only those records as result in looker dashboard in which my date is ‘2020-05-05 00...
Percentage of Total - in a Tree Map and on a Bar Chart?
Hi all! A quick question here that I can’t find the solution of… I have the number of orders per country. I wa...
how to know if my previous row is the same and label it
I would like to know if I can know the previous value of a column and depending on whether it meets the condit...
Looker filters do not recognize foreign characters such as arabic
Hello, I am trying to add arabic text to a filter to search through content but the filter reverts to question...
Stacked bar chart - value label when 0.00
I am not entirely sure if this is how the engine should behave. I have one measure stacked on top of the other...
count repeated values to get sequential order of occurrences
I am a basic user and only have limited access to create custom dimensions and table calculations. Would it be...
"Show Full Field Name" not formatted correctly in Map Visualisations
Hi, In visualisations with “Show Full Field Name” on, we expect: View Name - Field Name With “Show Full Field ...
Fixing color of line chart with dynamic data
I have a line chart with 6 lines… The first 3 corresponds to top 3 product by sales on a day and the other cor...
