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 ...
Forum Posts
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...
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...
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...?
Scorecard total doesn't match Bar chart total - Active Users - Google Analytics 4 Data
Hi,we are presenting google analytics 4 data with looker studio for our client.we have a scorecard and a line ...
[Google Ads]Creative assets reporting
I want to express the performance of responsive search ads by asset using the Google Ads connector.The number ...
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...
Running total last 12 months
Hi all,I am trying to create a graph where each datapoint is the sum of the last 12 months sales. For example ...
Tracking down filter suggestions
In admin panel -> Database -> QueriesYou can see all running tasks and it has a source column & details. I wan...
SQL Runner table field icons, what do they mean?
On the SQL Runner, when you click on a table and it shows the fields in the table, there are icons to the left...
Formula in custom field in Looker
I made a custom field with a simple X+Y formula. But the results of the addition (+) is not right. The X+Y res...
Heatmap using calculated column ??
Morning, I'm trying to create a heatmap based off a calculated field. From a simple table:Column A - UK postco...
Date Formula
Hello,I am looking to write an formula that will work out how days are left until a certain date, 14 Sept 2023...
How to carry one Dashboard filter to another Dashboard to apply the filter on target dashboard ?
Hi buddies....Here my question is 'How to carry one Dashboard filter to another Dashboard to apply the filter ...
How many ways can we create a view in the project
Hello buddies Im new to this looker BI platform. My question is how many ways we can create a view in the proj...
Implementing global changes to default chart lines in project
Hello :),A more advanced appearance of the chart line visualization can be modified by editing the chart confi...
if() statement no longer working. Anything wrong on my end?
Hi, I've had a report with a dimension (if() statement) that's been working fine for the past year until today...
Using a field from one view as a display filter but using another field to filter
Hi,The issue is we have a view called t_trade_product that contains the following:dimension: product_code {typ...
Aggregation: Sum of count_distinct type measure
I am trying to create a measure of type count_distinct and I want to use it in another measure using type sum....
Filter based on condition
Hi,I am trying to build a dashboard with multiple tiles, where they are related. The expectation is, when any ...
Adjust scatter chart x-axis units
Hello,I would like to adjust my x-axis so the dates will be showing intervals of 5 days. Just like in Excel (a...
Bug - not using HTML for tooltip or Axes labels
If you apply a custom formatting using html parameter to a dimension, prepare to have some problems when it co...
Simple solution for period-over-period reporting and pacing in Looker
Hi all, I wanted to share a simple solution for period-over-period and pacing reporting.Period-Over-Period1. S...
How to hide a column based on access_filter
how to hide a column based on access_filter.Assume we have a multi-tenant look and we are using the unit id fo...
Is this the best practice for having totals and averages available on the same measure?
Is this the proper way to do this? How do you guys handle the option for users to select either the average/mi...
Is there a way to directly upload data from an Excel file or CSV into Looker?
I serve as a Looker explorer at my company, where I endeavor to upload the data, independent of the warehouse ...
Schedule Looker Reports to G-Chat Space using Google Apps Script.
In our busy lives, finding ways to simplify and automate tasks is crucial for productivity. Thankfully, Google...
Series in Looker
How to create a constantly increasing column in Looker?Eg:10000, 20000, 30000, 40000, 50000, ....................
Get average of data where 2 pivot column match
Hi EveryoneI have a looker look which uses 2 pivot dimensions. You can see below. One is Degree term ID, secon...
Bar chart of Percent difference in the positive and negative direction
Hello everyone,I'm hoping to get some help making a bar chart to display percent differences in both the posit...