Looker integrations you can't live without?
I missed the whole year of efficiency thing in 2023, and am trying to catch up in 2024. Are there any blocks, ...
Forum Posts
Looker Case When Else return original values
Hi I have a column contains multiple values, (eg: 0, 1, 2, 3, ..., 200), and I want to show 0 as "No item" and...
how to compare the sum of two columns?
Hi! Please/// Help! My Google data studio data source returns a list of users. Each row has the user name, id,...
Looker - Can an end user access a hidden measure?
So in our team we occasionally add dimensions that are useful but not commonly used as "hidden:yes". This is t...
Looker Studio Pivot Table Calculations Not Working
I'm using Looker Studio and needing to build a report that shows the Users, The status of their projects, The ...
Find Prior procedure start time (surgery) for the same room same Doctor
I am trying to find the prior procedure (surgery) end time for the same room, Same day, Same surgeon same surg...
How to change font-size in Pie Chart Lables
I am having a pie chart with labels, I want to increase the font size of these labels.There is no oprtion in t...
Pie chart based upon two dimensions
Hello Looker Community,For one of our views we get a name column with a precalculated figure. Looker treats th...
always_filter: how to block the combo box for just before
Hi.I need for requirement to block the combo box for a date column with always_filter: because we want to give...
Show comparison periods in bar chart
I have a problem with Looker Studio that I cannot solve. I would like to display my KPIs (e.g. impressions), e...
Error trying to connect PostgresSQL
As you can see from the screenshot below, I am running into a status 403 error. Error ID = 8f7691ba Please fin...
How to do a Count based on Groupings
Hi, New to this forum, my first post actually. If I need to provide more context or examples please let me kno...
Scorecard don't show target metric
Hi guys! I have a scorecard that show sales from this quarter and compares with the sales goal. The field from...
Looker Studio
Dataset configuration error in Looker Studio for Average page load time metric.The reports were working until ...
I am looking to create a Calendar, HELP
i wanna create a calendar where i can visualize the time off of my employees, is it posible on looker?in a cal...
Overall Percentage wrong
Hi all,I have a google sheet which has many names within it. Each name has a number of days missed (days strip...
Bins using Measures
I have a dimension holding Customers and a measure which calculates total order_amountI have ranked the custom...
How to further roll-up a chart visualization?
Context: I'm trying to further roll-up this chart by rep and by account to show how many accounts had growth o...
Add first lead date to my product without breaking product rows
I have the following CTE running an explore (redshift). The idea behind it is to check product performance and...
Solving "Count Distinct" across multiple fields
Hello - I have a question which hopefully the dataset below explains clearly.In this example dataset, Legal en...
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...
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...
The total shows as null (phi symbol)
In looker while creating a table which shows created month, vendor name , num of dhr, num of ncmr and vendor e...
The total shows as null (phi symbol)
In looker while creating a table which shows created month, vendor name , num of dhr, num of ncmr and vendor e...
Month over Month help :c
i want the same period of days on a different month on lookerfor example, im comparing November 1-4(bc 4th is ...
Percent change from previous row not available when date filter is on.
I already created a column of percent change from previous data by date. but when I applied the filter date it...
sum comma separated numbers seen as strings
My report is meant to show by employee and by category total expenses. Im trying to sum values that are separa...
How could I show only the data that is updated
Hi. I wan to show only the data that is udpated in my dashboard.Is there any way to do that...?
How can I set a consistent color scheme for multiple horizontal bar charts?
We've set up multiple horizontal bar charts with different colors, and I've attached the visuals. However, the...
How to display a calculated percent of 2 distinct counts on a dashboard
How would I create a KPI on a dashboard this is a calculated percent of 2 distinct values. For example, if you...