% DIFF BETWEEN DATE Y AND DATE Y -1
Hello all,I was wondering how can I have a % difference between a metric shown on data range Y vs the prior da...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
create simple case statement in custom dimension or table calculation.
Why is it so hard to write a simple case statement in custom dimension or table calculation. Can some one help...
Dashboard Filters: Null Values
Hi,We have a dimension where there are NULL values. We filter on this dimension but there is no option to sele...
Dashboard filter doesn't show suggestions
Hi there, we have encountered some issues with dashboard filters recently. They seem to be hard to be cr...
ERROR:: Uh oh. undefined method `applicable_filters' for # when I download a pdf/png file from LookML Dashboard
Users might encounter this error message when user is in the dev mode and then tried to download LookML dashbo...
Bucket Dimensions as a Custom Field
I am making a visualization of clients served by gender. We have X male clients, Y female clients, and a few t...
Exclude a measure from being filtered
I have a table calculation with a query like below:count_distinct user_id / total_number_of_usersBoth are basi...
in Table Calculations - find distinct value AND last instance of duplicate values
I have a column of values where, in table calculations, I need to identify in another column whether that valu...
Formatting explore drill down pop-up menu
Hello, I need help formatting the background color for the explore pop-up drill down menu. (see attached pic f...
Dashboard tiles - resizing when editing browser window
Currently when editing a dashboard if I resize my browser window to a smaller size every tile changes position...
How can we turn ON/OFF reports from the Dashboard? and How Can we Download Reports in PPT format?
I have created various reports on looker dashboard. Can we download the reports in PPT format? Also, can we Tu...
alerts not refreshing
HelloWe have an alert set up in a dashboard, one tile with a count and the other with the rows.The tile with t...
Scheduled data send to PowerBI
Hoping someone can lend some advice on the best way to schedule a .csv to be sent from a Look to PowerBI? I’m ...
Calc Field
The Table calc field right now exist as a col calc. Can we add a feature that will allow to also do row based ...
Dynamically name y-axis from value in the data
I deal with different clients who deal in different currencies, but I want to deploy the same chart to both cl...
Text filter using diacritic marks
Is there a way to search for a value in the filter list that contains diacritic marks?My data has value “Valén...
Next-gen Dashboards - dimension group fields do not trigger scroll
Under the Plans there are fields but I can’t scroll to it because the scroll is only activated when the height...
Merged queries - can't add one after another
After saving a merged query, let’s say you want to add another one straight away. Upon clicking “Add Query”, a...
Merged queries - suddenly all gone upon save
This is a long shot but I’m leaving it here for posterity. I had to do a LEFT JOIN type of a table report that...
Adding row limit after previously removing it
We know the row limit in the query is set to 500. Sometimes I remove it and then the query is evaluated again ...
Unexpected end of JSON input
Quite a new thing that I haven’t seen before. Simple dashboard with one big table doesn’t get loaded and the c...
Projections on a Quarterly Basis
I have a set of metrics that, at any point in a given month, I can project what they will be at the end of the...
Reference line not rendering in visualization of merged results
I’ve added a refence line to the line chart visualization of merged results and it is not showing up. I’ve nev...
Filtering agent tenure in order to group by months
Hello everyone, I am fairly new to Looker and I have been tasked with coming up with a way to group employees ...
How to extract unique fields from a report that has multiple columns?
I have a table report that shows the number of times each customer visits a web site URL for each day. The. re...
Dynamically Filtering of a pivot table
Hi everyone!“New-Looker” here.I have the following data: Month, Country, Amount of sales (generated per month)...
Pendo feedback and feature requests
I’m seeing more and more topics around criticising Pendo and it’s issues. So I thought of creating a one topic...
Can you constrain the list of explores available in a dashboard?
We have a number of customers and we’re setting up Looker with one project per customer, and several models pe...
Colour collections and Palettes for Custom Visualization
Hi,I’m developing a custom visualization based on an external library and Looker documentation https://github....
Tip: How to filter a table calculation
Hi all, I didn’t find this in the forums, but I figured out an easy workaround so I thought I’d share. Say you...
