Only Show Value in First Row
Hi all. Finding my way around Looker after many years with Tableau and R. Thanks for reading. This is a very b...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Sendgrid Cell Level Integration
Hi, I’m looking to send emails to users within a dashboard as I’ve seen on some promotional images. I’ve been ...
Last day of last month user filter
Hi All, How can I use the advanced filter to create a filter to query the last day of last month? Or, should t...
Single value visualisation and value format
I’m following the Excel-style formatting but for some reason it’s not being formatted correctly. Anybody havin...
Pivot jumping over Table Calculation
I was editing a tile and upon saving this unusual looking tile appeared: As you can see the last value of the ...
How to create open-high-low-close charts?
Is it possible to create open-high-low-close chart like visualizations in Looker? s. example here https://docs...
Who Favorited A Dashboard?
I recently built a new Looker project as our old one had become too bloated and hard to navigate, and am in th...
Change display format of time dimension 'Hour' values in pivot column titles?
I have a pivot table display where I have a time dimension ‘Hour’ element displayed as the pivot field, as sho...
Parsing $ value from field including both strings and integers
Hey there, I’m trying to parse out the $ value from a field containing both integers and strings. Example The ...
Stats table calcs: comparing rates over time (Bonus: anomaly detection!)
If you haven’t already read my post on using the beta distribution for an A/B test, that might be a good warm-...
Calculated field with max row Limit
I have a table calculation returning the median of a column that surpasses the 5,000 row limit by enough that ...
How to use the Funnel Visualization
Hello fellow explorers! We are trying to take advantage of the Funnel visualization but are having quite the h...
LookML Developer Certification
Hello , Just wanted to know whether we can give Looker Certification from India? Regards Manoj
Incorrectly shown date
I used System Activity -> Users to look at the Most Recent Query Date and for some reason the new table visual...
Don't have access to a Look I created
Hi, I created a Look and for some reason when I saved it I get the following message, “You do not have access ...
Handling Suggestions when Explorer in is connected to Athena
We’ve got our data lake stored in S3 and we query it via Looker connected to Athena. Due to the runtime of que...
Nested Sorting
Looking for the ability to perform nested sorting within a visual. This was something I used on a regular basi...
Unable to create new View after attempt creating View with existing name
“Create View” does nothing after previous attempt creating view with the same name. Steps to reproduce: Click ...
Create a date range using a single value tile & table calculations
I’d like to display my tile as a range of dates e.g. February 21st 2020 - February 28th 2020. My first idea wa...
Definition of "dimension table calculation" and "measure table calculation"
Does anyone have a definition of “dimension table calculation” and “measure table calculation”? Or, given an e...
Schedule visualization cuts off rows
I have problem with one of my scheduled emails. In dashboard I have multiple tables with grouping on Creation ...
Measure/ Field Calculation for 'Daily Average'
Hi there! I am new to looker and was wondering the easiest way (or calculated field formula convention) to tur...
How to reference a field in table calculation that has not been selected in data but is in the filter
I have this data: Filters: issue resolution contains fixed, resolved, unresolved Data: issues severity(pivot) ...
Issue with merging explore results due to row limits
Hello, I was trying out the ‘Merge Results’ functionality in an Explore and I couldn’t make it work properly f...
Transposed metrics - fit the whole label
I’m using transpose and would like to make sure that the pivot that metrics’ labels that tet transposed are al...
Duplicated tile gets different row height
One dashboard. Same tile that has been duplicated. Suddenly one of the tiles got different (better) line-heigh...
Custom Visualization - Options
I find this (https://github.com/looker/custom_visualizations_v2/blob/master/docs/api_reference.md#organizing-o...
Custom Visualization based on Plotly
Hello – I am wondering if it is possible to develop a custom visualization based on the Plotly open-source vis...
Filter Suggest Cache
Hi, I am using a persist_with with datagroup at the model level. Also, I have a parameter suggest_persist_for ...
How To create a Heatmap (choropleth map) with two layers?
Is it possible to make a heatmap with two different layers? I have a list of zip codes and a count for each on...
