Reset Filters not clearing all filters with default values
I have a set of filters with default values. I’d like to allow users the ability to click “Reset Filters” whic...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
When pivoting by a dimension, the sum of values in the pivot categories do not match the row totals
For example, the total revenue in a given month is $1,000,000When I pivot by a dimension like product categori...
Changing Y-Axis Labels from Log to Linear
I have data in Log scale but I would like to change the labels on the y-axis back to linear for users to bette...
Enhanced Navigation Boards Load Time
Hi,We have recently started using the Enhanced Navigation and pinning dashboards to Boards to improve navigati...
HTML table in looker text box
I have a requirement where I will be needing 100+ tiles of single value dashboard. Instead of creating all the...
How to display nothing (blank soace) in the place of Null values (‘Phi’ symbol)
I want to display Null values as empty cell values, how can I acheive that.I neither want a Phi symbol nor 0 d...
PSA: When data columns and vis columns are in different order, downloaded data will have incorrect headers!
Hi All,I want to create this post to make you aware of this bug. I have contacted Looker Support, but was simp...
Merge Query
Is merge query feature in Looker going to be removed in near future
Aggregate non-numeric values
Hello, I want to create a single visualisation of a the total number of people that were active for a particul...
Similar function to "TextJoin" in Looker?
Hello,I am looking for a way to Text Join with conditions in Looker. In excel, I used to do a simple formula l...
Visualization error in v21.20.23
Hi, We recently upgraded to v21.20.23 and we are seeing the following error in visualizations. Do you have a f...
Is there something like JSON pretty print to display an object in a Look?
I have a BQ table that contains a column that is being used to store a JSON object of customer specific conten...
Custom Single Value Viz
Hello,I want to show the custom field - table calculated value in custom single value viz. In custom single va...
Table with subtotals doesn't meet users needs
Hi there, We’ve just adquired looker as our new BI corporate tool. We’re already created some models and dashb...
Grid Layout and measure colour persistence
Hi everyone!I’ve got following problem with the Grid Layout: By Pivot feature - It segments the chart labels a...
Unpivot one dimension?
I want to show revenue of 1. price discounted items, 2. package discounted items, and 3. all discounted items....
Dates incorrectly displayed after Look is downloaded to Excel - Unparseable date
This issue needs to be reopened:https://community.looker.com/dashboards-looks-7/dates-incorrectly-displayed-af...
Accessibility and Chart Keyboard Navigation
Hi, is there a way to modify the tabIndex of the columns or bars in your charts? For example, in one of our ch...
Select date in between
HiWe have subscriptions for our customers. So the table would look like this example: # Customer Date Start Da...
pros and cons of using table calculations in looker
pros and cons of using table calculations in looker
Failure when download dashboard
I encountered the query error when trying to download dashboard results as pdf or csv. Dashbard works as expec...
How to make the filter value to be remembered when passing filters from one Dashboard to another?
I have two Dashboards, Dashboard A and Dashboard B, Both the Dashboards are updated to pass filter from one to...
How do I create a dashboard filter that will return data only from the last day of each month for the last 12 months? Thank you VERY MUCH in advance for any assistance!
Subject line pretty much says it all Please post any follow-up questions that would be helpful
Map Error seems Browser related
I am getting a Map error and another community post said it was a Chrome issue? It worked earlier this week an...
Need help building mutliple location dashboards
Just seeking helpful resources on how to build better reports for clients with Looker. I often feel the platfo...
Cumulative sum wich multiples conditions
Hello,I have a soccer’project with multiple league .I want to create measure to sum the points by team by stag...
How to summarize daily sales data with quarterly sales targets?
I have daily sales data (from Salesforce, if that’s helpful) that I’d like to summarize on quarterly, regional...
Adding in the Custom Expression field
Hi,As you can see in the image, I’m trying to make a column that shows the value of 3 other columns combined. ...
Heatmap or Matrix Visualizations?
Is there going to be an effort to create a fairly basic heatmap viz? I have a growing need to visualize data i...
Is there any way to create a Demo dashboard without data?
I am looking to create a demo dashboard for an upcoming project, but we don’t have the data. We know what we w...
