Filter multiple values at same time on dashboard without rewriting
Hi!I have a filter I need to apply in order to filter Stores, by name, on a dashboard.They all start with the ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Pivot by 2 fields from 2 different explores
There is a ‘company’ table. This view joins to a ‘content’ dt that includes the number of content that a compa...
Looking to group by Measure instead of Dimension on Column Graph
Hey there,Is there any way on a Column Chart to group by the measures instead of by the Dimensions:For example...
Filter across dashboards
I’ve done it before, but for the life of me can’t figure out how to do it now. I want to be able to cross filt...
Sum for table calculations
I have a table calculation for my “net” column where each row has items of a specific value.Normally, the tota...
Can't download expanded tables
Hi,We have a dashboard that we can’t download. When trying to download with the option of “Expand tables to sh...
Tooltip download
How can I download the data in tooltip?
Are merge results with *dashboard* filters filtered before or after the merge?
For example, let’s say I have a dashboard with product sales merges three Explores, on the “Product Class” dim...
Format date result of table calc/custom dimension as YYYY or YYYY-MM
Whenever I create a table calculation or a custom dimension that should be in date format, it always comes out...
Date grouping across multiple tables and measures
I have LookML definition that has 3 views, and explore model that joins all these views.Each view has some mea...
Can you download a looks data into a preformatted google sheet?
Hi all,So I have a look that pulls data for product sales, the Look returns Product Name, Sales, and UPC numer...
Uh oh something went wrong on looks in the dashboard
The pre- built dashboard which was working fine for sometime. Suddenly shows an error message on all the looks...
Difference between View name and View file name?
We can see that the view file name is different from the view label name.What happens when both are mismatched...
When users export content from the dashboard, replace "by Looker" with nothing. It should display "Generated on **** ".
I want to customize this to Generated on February 24, 2022 at 1:18 PM IST.Could anyone help me with this? How ...
Date Filter current day @ 06:00
How to I set a date filter for the current day between 06:00 and 18:00?The current date needs to be relative a...
How to set "is between [inclusive]" instead of "is between [right-exclusive) in drilldown?
I am using simple histogram chart and drilling down from a histogram column (for example, Account count in x-a...
Table sort orders are being reverted on dashboards
We have a table widget on a dashboard that is sorted by a particular column by default. When users (including ...
Multiple Comparisons on Single Value
Hello everyone,As I am using the Single Value visualisation for one of my dashboards, I would like to have mov...
show measures in look dynamically based on value in dashboard filter
Hi, is it possible to make the set of measure shown it the look change when I change the dashboard filter? For...
Dashboard LookML error when viewing from Shared Folder
Hi,Built Looks and Dashboard_1 in Development Mode. Looks and Dashboard_1 are available in Folders → My folder...
How to change null value to blank?
When downloading looks to csv format via webhook, all null fields have the literal word “null”. We need this t...
Looker Explore adding extra functions impacting performance and accuracy
Hi,After adding the dimensions and measures in Looker explorer when looked at the generated SQL I see lot of f...
Map Viz Limits
Hi!I was trying to look for the limits in each map type and couldn’t find it in the guideshttps://docs.looker....
How to avoid trunc date in explore joins
Hi,When exploring multiple columns views are joined based on the joins defined in model. But I am running into...
Populate parameter labels and values by query result
Hi Community,I don’t think it is currently possible but it would be very helpful if a parameter’s label and va...
No "Format Data As" Option in Looker Instance
I currently work on multiple instances of Looker, all at version 7.12.29. Currently an upgrade is not possible...
Scatterplot as a matrix
First of all, big thanks to @lindsey1 as this is a follow on from her topic Measure vs. Measure Scatterplots (...
Update suggestions of a dashboard filter based on the value of another filter
Hello,let’s assume that in a dashboard we have the two following filters: ‘country’ and ‘city.’After I have ch...
Change Name of "More" or "Filters"
Is it possible to change the text shown when putting filters behind the “more” button? For example change “Fil...
Filter with tag list based on another filter that is liquid
Hello, I am trying to get a tag list in one filter on my dashboard that is limited with available reasults bas...
