Custom Field won't show up in future months....
hello - I set up a custom field as a measure, and I attempted to populate it for all months in 2020, but it wi...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Shared filter for multiple dimesnsions
Hi, I’m trying to do the shared DateRange filter for using in 2 dimensions. 1 dimension is a just table TableX...
Table visualisation doesn't format duration type correctly
This is results tab: and the vis tab: Again back to using table legacy : (
Dashboard filter value showing partial suggestion data
Hi, When I click the value field from the filter as shown in the screenshot, it shows only partial suggestion ...
Series' font sizes as comma-delimited list not working
I can’t get the different font sizes to work in my visualisations. I have three series like this: Colours work...
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...
? 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...
