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...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
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...
Using table calculation functions and operators to create window functions
Not directly - however, you can create window functions by using some complicated table calculation formulas w...
Need to calculate a column average - please help!
End Goal: Compare Q4 rep averages to Q1 rep averages in 3 specific columns. This seems like it should be so si...
As close as you can get to a Bullet Graph with Looker's out of the box charts (Actual vs Target)
Hello there Looker community! I’ve been building bullet-like graphs for quite a lot of clients so I thought I’...
Creating a running total across rows with table calculations
You can create a running total across rows with table calculations using the pivot_offset function. You can al...
How do you tell people what tiles are affected by dashboard filters?
Hey guys! As the title suggests, our team is struggling to find an easy and maintainable way of communicating ...
Stacked bars comparison in the same chart?
Hi - I’m looking to represent a comparison between current and previous year for stacked bars. Is this possibl...
Dashboard layout type "grid" is not supported.
Hello everyone,I’m new to Looker, and I was trying to use a Block from the marketplace. Everything worked perf...
