How do you remove a carriage return from a string value in Looker?
I am editing a Look for a customer and I am trying to understand how you would remove a carriage return charac...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Looker Actions - same action showing twice?
We’ll often see the same Looker action twice, even though only one exists within the explore. Does anyone know...
Illustrating hard coded calculation values in a table
Hi there!I’ve got a look in which I’ve added monthly goals as “hard coded numbers” in calculations for each ci...
Line Chart
Hello,Given a Line Chart showing data for the current week, with the x-axis being the date, is it in any way p...
Emojis on Looker
Hey, everyone! I'm trying to add emojis on the title of tiles of my dashboard. At first, it seems to work fine...
Problem Downloading PDFs
Hi,We are using the functionality of downloading dashboards as PDFs but when there are custom visualizations n...
Filling in Dates, but not for dates but for integer numbers series in x axis.
Some day someone asked how do I go from here:Missing cases in an integer numbers variable in X-axis are not pl...
Scheduling alerts for weekends/weekdays
Hi Looker Community - How could I go about creating a dimension that take sum of amount on weekday orders only...
Adapting tile size to comments length in schedules
Hi! We currently have a dashboard that gets notes written on most tiles each week. Each week that dashboard an...
Moving explores between projects
Hi!Is there any way to avoid building a new dashboards if I move the explore the tiles of the dashboard are ba...
Looker Explore Date Filters change
Our team noticed for all our data, when filtering by a date , Looker now shows Jan 1, 2021 instead of 1/1/21. ...
Unified date filter
Hi everyone,I have multiple views which have 2-3 date columns for different set of metrics.For example- Metric...
Grouping creates an extra ghost series
I’m grouping a field and using those groups as columns in the Data Table - when I look at the visual it seems ...
How to calculate keyword density?
Hello, I am trying to calculate the keyword density for a web page i.e. how many times the page title appears ...
Single selection drop down filter for Dashboard disabled even in edit mode?
Hey everyone, I just created a new dashboard that has this first single selection drop down filter. I set the ...
Print PDF report and Columns Getting Cut Off
Hi,I have a big table with 33 columns. When I tried to download the report, I have about 12 columns getting cu...
Can't create alerts / not seeing alert icon
Hi - I am out of dev mode and can’t see the bell icon on the tiles to create alerts. Not sure why / is there a...
Count the number of times a string appears in a column
Hi Everyone,I have a process that sends error messages to the platform. I want to retrieve the most common err...
Custom Dimension: Changing font color based with function based on result
Hello to all,Writing you with a simplified version of my issue, as I’m looking for a coded way to change font ...
How to see more results in admin schedule history page?
The schedule history page is limited, so in cases we want to see more results we can use system activity’s sch...
How to ensure webhook security?
Hello everybody,I am planning to use webhooks to send data to a third party system and my developers are quest...
"An error occurred for action looker-integration://1::google_sheets"
For the past few weeks, I have gotten the following error message with my Looker Google Sheet schedules:“Error...
how to make dashboard lok the same on different screens?
Hi there,I am trying to make my dashboards look the same across the organisation when each user looks at it wi...
Dashboards look differently between colleagues
Hi,One of my colleagues created a dashboard and shared it with the team.Some tiles looks different for some us...
Count "Active" Contracts Between Date Windows
I’m stuck on a problem which i feel should be simple. I have data that looks like thisStart Date End Date Stat...
An alert on a dashboard just contains dimensions
I have a dimension of type string and I want to apply an alert once the value of a row of this dimension is nu...
Change the Model of a dashboard from A model to B model (Dashboard lives in B model but looking at A Data model)
Thanks you all for helping here.Request I have: We have a dashboard that is created under GSS's data model. Ho...
Dashboard level filters
Hello,I have a data field in looker in number format, for employee’s days of service. I added this field to th...
Filter Dashboard on last working day
Dear Looker folks,I need to filter by default my Dashboard on “last working day”, ie :if today is tueday, the ...
Calculate last 7 day average
I’m trying to calculate the last seven day average of unique users by day. Then display that against thirty mi...
