Default Visualization for Quickstart
Hello,I’m attempting to create a quickstart that’s simple for my looker users. When I click on that quick star...
Forum Posts
How to convert time duration(Ex.. like 1d 5h 12m 25s from 55678900 seconds )
Hi,i am a looker developer i need to create one look.i have a dimension called duration,dimension: duration{ty...
value_format to show Duration in Days Hours Minutes Seconds doesn't work
I am trying to create a visualization to show the duration as dd days hh hours mm minutes ss seconds format. S...
Implement vertical "writing-mode" in Looker "Table" visualisation
Hi,I wonder any expert out here can help me please.I have a tabular report in Looker that has one pivoted dime...
Feature Request For allowing all zip codes on map visualisation
Feature Request here for allowing the Zip/Postal codes of all the countries , cities and states currently in M...
Bug not resolved: bind_all_filters option in NDT persists
I am trying to drill down from a measure (count_distinct) in a pivoted table. The drill down fields work corre...
Max Date Time from Partitioned by Client
@izzymiller or anyone can you give some suggestion, if there is a simpler way to do it? We have clients, and d...
Line chart of weekly accumulative unique values
Lets say I have a data table like belowid uuid date 1 1 2023/04/04 2 2 2023/04/05 3 1 2023/04/11 4 3 2023/04/1...
Dynamic QoQ in Looker
How to do QOQ analysis in looker in dynamic approach, for example if the user selects 2023 q2 it should compar...
parameter for finding zoomlevel of map in looker
Is there a way to find the zoom level of the map through lookml code,my sql looks like this SELECT CASE WHEN m...
Table Calculations without row limit
Hello,I have a sales table by seller. I want to calculate percent of sold quantity by each seller. But when i ...
Find range (Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Unknown Error Just Started Today on Daily/weekly scheduled reports
This error is being thrown with schedules. It only began today and no changes have been made to the schedule o...
Issues displaying long comments in table
Hi all, I have a table inside a dashboard that shows 5 columns including one for comments. I am having a issue...
Data source loads, but can't visualize
The following code ran in Looker and created a data source without issue. But when I went to create a report, ...
[Analytic Block] Flexible Period-over-Period Analysis
Looker has created this block to make analyzing data easier and more efficient. This Data Block is made availa...
Dynamic Drilldowns via Corresponding Dimension
Is there a way to dynamically change the drill field set attached to a simple count measure based on the dimen...
One Button Solution - Period over Period Analysis with a Set Trend for each Date Type
Hi!What I currently have is the following:A “to date filter”, that filters yesterday, weekly, monthly, quarter...
Draw polygons on map in looker
Hi,I have a geojson file that contain several polygons, how can I use it and upload it on a map it looker?
Reordering drill_down for measure to come before any dimensions
Hi community, I have a count_distinct measure that has drill_fields set to using a measure and a set of dimens...
one fact table with multiple dates
Hi, I am working on a project that we have some questions about.The project works as a star schema, we have on...
Creating a custom Date dimension in Looker Studio
Hello, I’ve been dealing with an issue when blending data from two different Google Analytics Universal views ...
Looker visualization mysql issue
I connect to mysql server to visualize data into looker. I have column which has dates in text format. The tab...
Counting unique id's in one column
Hi,I am new to Looker and am having various success and can see its a very powerful tool but i have hit a poin...
Multiple hyperlinks in one cell
Is it possible to show two or more hyperlinks in one cell in Looker?
Color coding on one dimension based on the values of another dimension
Is it possible to have conditional formatting on one dimension based on the value of another dimension in Look...
Tracking Pill clicks in Looker dashboards
How do I track pill clicks in my Looker Dashboards. There’s no event that is being registered in System Activi...
Moving calculation column within Merge Queries
On my merge quiries, I created calculation between two queries. As default all calculation are placed at the v...
End date rows are not merged after download
Hi,I have on Visualization table legacy some data which are grouped by “End date”, but once I download the fil...
Dim Date table to another table How to create relationship? b/w two tables?
Hi Team,i have a 2 tables called product and dim_date.now i have to create relationship b/w the two tables usi...