Limit results in a table based on the largest value of a dimension
I am looking for the equivalent to what I know as a level of detail expression in Tableau. Here is a small sam...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Stats table calcs + Timeline viz = Easy A/B Testing
Disclaimer: The statistical methods in this post are Bayesian. I strongly prefer Bayesian statistics over freq...
Cross filtering some tiles not all of them
Hello everybody,I want to know if there is a possibility to isolate one or more tiles from being cross filtere...
KPI Rendering on a laptop
We have a customer who uses a laptop only. They have closed the Looker side bar and have changed their Zoom to...
Forecast labels are black
In case you notice that some labels or even data points are suddenly black. Same thing happened with tooltip t...
Client Lifespan Custom Calculation
Hello!I am attempting to build a look showing average client lifespan.The applicable dimensions are client_tie...
Will "Convert Look to Tile" be available with upgraded dashboards?
Currently, upgraded dashboards do not seem to support the “Convert Look to Tile” feature that legacy dashboard...
Date Range in IF Statement in Table Calculation
How do I use a date range in an IF statement in a table calculation? I’m trying to use a nested if statement d...
Date Parameter - Single Date Only
We’re creating a number of explores, looks, and dashboards based on a reference date parameter. We have logic ...
Why are dashboards with "preferred_viewer: dashboards-next" loading legacy dashboards as of yesterday [10/28]?
As of yesterday [10/28], when I open a dashboard that has the “preferred_viewer: dashboards-next” parameter, i...
Group by Fields Value
Hi,I would like to created mathematical operations grouping by country. For example, in this case, the average...
Cell Visualization Default
Is there anyway to turn off the automatic cell visualization default for the first numeric column in an explor...
Calendar localisation
My calendar shows the dates in US format:How do I change it to DD/MM/YYY and 13 Dec 2021?
If or Contains Table Calculation
Ok so I’m not really the sure the best way to go about this. I’m looking to create a calculation that will ret...
Full field name in new filter selection in Table Calculations
Sometimes I have the same fields that are name with full scope but labelled and grouped for clarity:revenue da...
Multiple currencies management in a dashboard
Hello there,I’m looking for an efficient way to manage the display of reporting in various currencies.We are a...
When "Enhanced Navigation" is enabled, I cannot narrow down the search using the description
Hi,When Enhanced Navigation is enabled, I cannot narrow down the search using the description.For example, I w...
Version 21.20 new dashboard renderings for clients with CNAME records
I’m troubleshooting and issue with my company’s reporting dashboards. This issue is caused by the Looker updat...
Question about Looker Dashboard
I'm trying to create a copy of a dashboard as I need the info in the columns of a dashboard but for only a dif...
Line Chart
Can we normalize the y-axis between two line charts so it is easier to compare?Details: Currently, the charts ...
Expand the text within a text Tile
Hi, I have a text tile with some definitions on KPIs and also “Read Me” information on a dashboard. I don’t wa...
As the creator how do i get notified in slack?
Hello, The way we are currently using this integration, if an alert is made through Looker to push to Slack, L...
legend order on the sides is upside down
Hi all,The stacked column legend’s order when is on one of the sides is upside down.x series should be on the ...
Why aren't partition key enabled for Impala?
Our instance uses Impala and recently we enabled PDTs to fasten report performance. However the PDT tables are...
How to compare values in two columns in custom filters
Hey! I faced this issue, when I need to compare every value from one column with every value in the second col...
Single Value viz not showing the correct value
For a dashboard I have created I have a tile which is supposed to show the percentage change from previous the...
Is there a toggle option in an explore?
Hi all,Let’s assume I have the basic table below in an explore:Date Name 12/1/2021 alpha 12/2/2021 beta Is the...
Upgrading the default dashboard experience for all Looker users!
Hello everyone! Very excited to share that with Looker 21.20, we are upgrading our default dashboard experienc...
How to Calculate 12-Month Trailing Average (TTA) in a Look
I’ve figured out how to calculate a 12-month trailing average (TTA) in a look for the purpose of understanding...
Single value showing different than in explore
Hello! I created a pretty simple tile for a single value visual where I am using the 'percent from previous' a...
