Error al conectar mi base de datos hacia Looker
Un error común en la conexión entre tu base de datos y Looker suele ser: Cannot connect: connection refused: J...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Duplicate values from Google sheet are not displayed on looker studio
Hello All,I am using google sheet as my data source for the looker studio report. However, there are some dupl...
No Data to Show on Dashboard Tile - Error
Not sure if this is something that's changed but I have a dashboard that sometimes, when selecting a filter, w...
Creating a window function inside a table calculation/custom measure
Hey all, I’ve searched everywhere and couldn’t find an answer i would like to emulate a window functions in on...
Need Assistance with Table Calculation: Summing up value after group by
I have obtained the above data (a sample of it) from a derived table. My objective in Looker is to achieve the...
Bars in tables not scaling correctly
Hi Looker team, We are seeing some odd behaviour with the bars on a table visualisation, see screenshot. Note ...
Table with bars scaling incorrectly (truncated)
The bars are sometimes truncated for me. This is affecting me in multiple dashboards, not all columns impacted...
Customize Data Coloring Based on Data
Hi, I need some help.I have data that involves colors. For example, imagine I have a table with the following ...
Possible bug - Yes/No field in Single Value Tile
When I add a dimension alongside the Yes/No boolean value, we see one row:If I remove the dimension, leaving f...
Custome Field for Week ending date
Hi,Can anyone help here..i am looking for a custome field showing week ending dates from a give date field. We...
Scatter plot: Add label from hidden field
I have a scatter plot which displays X axis - count of pensY axis - count of colorsBut these are grouped by br...
Microsoft Ads > Looker Studio
Please may you advise on the best way to bring Microsoft Ads into Looker Studio reports. We are not wanting to...
Blending FaceBook and Google Ads data
Hi Everyone,I am trying Data blend using Google Ads and FaceBook Ads, now i want to show impressions, clicks a...
How to filter on filters?
Hi,I found when I want to only display data with certain conditions on the dashboard, I could add 'always_filt...
Filter to show non-selected values
Hi,I am creating a dashboard and want to show data in 2 separate tiles. The first tile will be the selected wi...
Removing months with no data from line charts
HiI am new to Looker, and I want to find a way to remove months from my line graph where there is no data.I ha...
Convert a null value into a Text String using Custom Dimension
How can I create a custom dimension that will convert a dimension that is null into a specific text string? Fo...
Weighted average based on dates selected in data range control
I am looking for a way to calculate the weighted average (based on the nr of people for a given score) in a sc...
Looker dashboard shows error when developer mode is off
Any idea why my Looker dashboard shows errors when I turn development mode off? I am new to Cloud Looker. So a...
how to change date format to 'mm/dd/yyyy' from 'yyyy-mm-dd'
I am trying dimension: tdate { type: date sql: DATE_FORMAT(${TABLE}.“TDATE”,’%m/%d/%Y’) ;; } but not getting o...
Centralizing an URL in Dashboard Tile
Hi all! I am trying to centralize text with a hyperlink on it on a dashboard tile. I used and Search to centra...
Can we chart cross filtering for chart and table in different page?
I have bar chart in page 1 and table in page 2 that contains of data details of the bar chart in previous page...
How to install specifics versions of Chromium? (Avoid installing +98v for customer hosted instances)
Lately, we’ve been seeing issues with rendering and some other functionalities related to Chromium, but only f...
Dashboard filter suggestions persisting between dashboards
Hi,In this scenario I have Dashboard A and Dashboard B which share Filter 1 and Filter 2.When I select from Fi...
Dynamic title on Slack alerts
How can I add the current date in either the comment/title of a Slack alert I’ve creates for my dashboard?
labels on bar charts, help
I just wanna know if there's a possible way to put the labels like this on the charts bc always happened somet...
Plans to increase email attachment size?
Looker email attachment size is still capped to 15 Mb, but numerous email applications allow more than that no...
How to set two filters to the same value in joined explore
I have an explore that is two views joined by id. Both views have a required time filter (to properly query a ...
How to visualize clicks over time (based on GA hour) for each line item?
In this example, I have a number of posts for which I am pulling in Clicks (Hits) per hour from GA. How can I ...
Looker Studio| GA4 - Filtering Sessions with duration gt 1 sec
I'm trying to filter out poor quality users by filtering out sessions less than 2 seconds.But it looks like th...
