Stacked Percentage Bars: Sorting Asc. or Desc. doesn't work properly
Hi.I've noticed since last week that the way some of my Stacked Percentage bar charts are displayed in some da...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Adding different fields to drill through
Hello, I've look through the docs but I haven't been able to find the answer. I'm wondering how I can change t...
Get latitude/longitude for any location through Google Sheets and plot these in Looker
_In this post we’ll explore an easy way to enhance your geodata using Apps script and Google Maps service, whi...
Case statement to sum a value based on another value???
A financial analyst reached out to me and asked that I implement a measure to an Explore he uses frequently.Th...
Count occurrences in a single column with
I have data that probably looks something like this:DateLabelUser2023-09-01Foojdoe2023-09-08Footvargas2023-10-...
Count number of group occurences
Hi. I am fairly new to Looker and I'm struggling with a seemingly simple concept. I have the following data:Th...
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...
Issue with aggregation & date range when using case when statement
I have some sample data HERE that feeds into the Looker Dashboard HERE. The sample data consists of campaign d...
Memory exhausted when using an explore?
Hi all,I have a fairly complicated CTE that works in the SQL runner (1m 15s) runtime. As soon as I try to use ...
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...
Visualisation Advanced Editor
Imagine my surprise when I had a training session and somebody asked me if I can change the order of measures ...
How to make the date criteria dynamic?
Hi,I have below formula that count the headcount for specific month "Aug 2023), what I need to do is adjusting...
Calculate Current Headcount and Rolling 12 Months Attrition Rate
Hi,I have 2 tables: one is for active headcount of the past 24 months, each month headcount is differentiated ...
Problem Saving Dashboard changes when editing merged queries
This works:Dashboard, two panels, both with a single queryEdit Dashboard, Edit first panel, edit an axis to hi...
How to download all the tiles in a looker dashboard in CSV format?
Is there an option to directly download a CSV file of a dashboard/tile through looker APIs?For context here is...
Sum of clicks for keywords is not matching with the Total clicks in looker studio
Hi, We used Google Looker Studio to download the total search queries we have received for our site, as the se...
Looker Dashboard Filters - Number Type
Hi Team,I’m having an issue with a filter on a dashboard with the type = number (in this case its a member num...
Looker Expression assistance
Hi -- I am new to Looker and am wondering if someone knows of an expression. I need to create a new column bas...
Dashboard filters not retaining filters after making changes
After creating and saving a dashboard, the Looker filters do not retain their filters after making additional ...
Help needed with Drill Up/Down
Hi all. I've been working with GLS for a few months and I've hit a bit of a wall with my understanding.I have ...
Change Point Size in Scatter Plot
Hi All,Is there a way to adjust the point size for the points in a scatter plot in an explore?I have a pivot t...
SEO dashboard for multilanguage website
Hello. I want to build a dashboard on looker to keep track of my SEO impressions, users, (etc.) by languages. ...
LookerStudio
Hello, I have linked GA4 to looker studio.In GA4 I have 3 different conversions active :call_back_formappointm...
The header color formatting does not work as expected.
For some reason I am seeing that the header color format is getting disturbed as soon as I truncate the text c...
Looker Schedule delivery
HelloI've some questions on schedule delivery in LookerI'm trying to use the Email type of delivery of a repor...
Exclude traffic if three conditions are true
I have a spike in my report and I have found out the reason is traffic with these conditions- Session default ...
AND/OR Filters in Explores not always available.
We have enabled AND/OR Filters in Explores. The option to toggle between AND/OR is available for some dimensio...
Concatenating rows in a table
I am looking for a way to concatenate a group of string which all appear in the same column, however in differ...
Setting range filter dynamic default
Hey all,I have a range filter on a dashboard, and I want it to always show until yesterday.example: if today i...
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...?
