updating a table calculation
I need to update the target column to be 20% below the external goal which is the same amount. I tried this lo...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Last date in a table
Hello everyone, I have a question about the data type: date in Looker.I need to show the last date where a pro...
Timeline visualisation seems to be very limited?
Hi everyone,I’m currently trying to build a Project Roadmap visualisation in Looker and I’m noticing that the ...
Create a Visualisation showing ONLY percentage line
I have a Look with a simple pivot table: the rows are week numbers (Week 01, Week 02, etc to Week 12) and the ...
Drill fields on DIMENSION
We could able to drill_fields for a field which is defined as MEASURE, however same drill down is not possible...
Can you fix the area of the squares in Automagic heatmap
Hi,I hav recently discovered Lookers Automagic heatmaps visualization. I can see that the squares change in si...
Table value Calculation by filtered dates
Hello,I am a bit stuck as I want to make a little table calculation taking into consideration the date I have ...
Dashboard Not Refreshing
I am changing anything in my dashboard and I saving this. But it is not refreshing.Dashboard still shows old v...
(LOD) Make Measure Value Fixed Regardless of Dimension in the Visual
Hello, I want to share my knowledge regarding Level of Detail (LOD) - Fixed as in the features in Tableau.Here...
New font (Google brand) doesn't show underscores
Google font at 11px doesn’t display underscores properly:
Reference Dashboard Filter in Custom Measure Custom Filter
I have a dashboard that filters all clients that were enrolled in a program through a certain date range, and ...
How do I change the size of text boxes for filters
Is there a way to change the with of the input box on filters? The size of the box truncates any long names so...
How to dynamically change the unit of time in the look, based on the time filter selected by the user?
Hi,Let’s assume a very simple case- one date filter on the dashboard and one look with “Order Month” on its x ...
WYSIWYG tile - how to remove?
I noticed the new tile type in Labs and just wanted to try it out but I realised that there’s no way to remove...
Calculation to Select Number of Days within Date Range where Criteria is Met
I am looking for a way for the output in a table calculation to be the number of days within my filtered date ...
Need Help with grouping range of days in a week
So I was ask get the weekly data score of each team we have, but in each week only Sun - Thurs data shall be c...
Search Bar Showing Archived Dashboards
Hi all,We have currently made a pretty significant update to our underlying data structure that meant a number...
Decrypting PostgreSQL data in Looker and then doing calculations
We have few data in PostgreSQL DB which is in encrypted format. We could able to decrypt data using pgcrypto m...
Custom Filters: How to filter by "starts with" while also using an OR statement
I am trying to create a custom filter by narrowing down what a dimension starts with while also using an OR st...
User filter for LIKE and wildcards
In SQL (SQL Server) I would use: Col LIKE '[A-L]%'to find all Col values starting with letter A through to L.H...
Looker Filter that can evaluate to more than one condition
I'm trying to create a filter for my dashboard.I need the filter to be able to evaluate to more than one condi...
Total bar on chart
I’m grouping a measure by a dimension, and showing this as a bar chart. I’ve clicked ‘show row total’ and I wo...
Unable to Download results
Hi,I’m trying to download results from a dashboard that has less than 100 rows. The results from row# 15 are g...
Extract string within a string then pivot on values
I have a column called ‘TAGs’ with the below string for a row in question:Looker_Channel:Search,Looker_LOB:Ret...
Spreadsheet-style format code to show both numbers in Millions and Percentages
In the chart above, I am trying to visualise absolute numbers in Millions and MoM% change in percentages. In t...
COUNTIFS Custom Calculation Function in Looker?
I’m trying to replicate a COUNTIFS function in Looker, and cannot figure it out for the life of me. The COUNTI...
Change the name of binned custom dimension labels
I would like to change the naming of labels for bin intervals for readability:I can’t figure out any way to do...
Two series with different filters applied to the same table on the same chart
Hi,I’d like to draw two series of sells over time :sales of group of customer (a WHERE) a specific customer sa...
How to use parameters values to two different Looks
Hi All,Is it possible to toggle two different Looks on a Looker Dashboard. Scenario - I have two parameters ca...
Multiple times series with different X axis
I have two tables : `groups` and `messages`. To keep it simple let’s consider this :I am able to create two se...
