Unduplicating Rows and Aggregating Sums by Date without LookML Access
Hi,I’m currently working on a Look that displays revenue at risk dollar values associated with billing errors ...
Exploring & Curating Data
Everything that a data analyst needs to know about accessing, viewing, and presenting data with Looker.
Forum Posts
Incorrect dates fed from Data Connector
Hello!I have an issue with my Looker Dashboard, especially Dates, I create it based on Salesforce Reports used...
Funnel chart - formatting percent
Hello all.I would like to format the percentage of a funnel with two decimals, like shown in the documentation...
Multiple datasources/pages with same filter
I have multiple data sources that expose different metrics about multiple projects.My report will have multipl...
Calculate weekdays from date filter range
In want to create a statistic where I calculate the amount of work hours (weekHours) available in a specific r...
Looker Documentation on "Location" type when Mapping by Country
Where can I find documentation on what Looker expects to see on “Country Names” in order for mapping capabilit...
How to enlarge the text in the text tile ?
Hello, I’ve created a KPI’s dashboard and I want to embed it in a Confluence page, the thing is that the text ...
Pie chart from 3 columns
Hi there, i want to make a pie chart that take the sum of 3 columnsMi data source looks like thisAnd I want to...
forecasting revenue
The goal of this is to dynamically add lump sum of revenue to account for projected/potential revenue) within ...
How to create a field for a specific time span e.g. Year1, Year2 where the period of time is bespoke
Hi New User here.I’m trying to create a field that will allow me to add a chart that can show two Years so tha...
Bar charts total issue
looker studio bar chart is giving me total of all the rows, as in my data i have unnested the array which is w...
Field Added to Data Source - Formula Only Look Between Specific Dates
Hello All, a conversion source in Google Ads changed and I wanted to only pull a formula rule between a specif...
Quota usage/token usage
Hi there, does anyone know a way of seeing how many tokens my looker studio reports are using? And the amount ...
Retrieve data from looker iframe in javascript and navigate in and out of an iframe
So I have this task to retrieve data from a looker iframe. Like when a user clicks on a particular order id th...
How to create a calculated field which is customized based on filter selection?
Hi there, I have created a custom drop-down list (using CASE WHEN formula) which groups campaigns together bas...
Formula for average daily views
Hi!I’m trying to showcase the Average Daily Views to my site through Looker but I can’t figure out what the co...
Google Analytics (Universal Analytics) goals in looker report
Hi all,does anyone know how can I create table like this in Looker Studio?I can’t see these fields, when I con...
Make denominator of percent total calculations unaffected by filters
I’ve been searching around and can’t find an answer. Hoping to get some help here.I am trying to create a dyna...
Add a dynamic average line to a line chart visualization
I have a line chart with a count of months on the x-axis and a cumulative count custom measure of some metric ...
Why are Looks data (ie: IDs) null in System Activity History ?
I created an explore to query system__activity-history to query look’s execution: model: system__activity view...
percentages pivot table
Hello,I created a pivot table, with the years in columns, in row user_choice which has 2 choices, and then I d...
Column Header Alignment
HiIs it possible to right align individual column headers in a table. you seem to be only able to left/centre/...
Download to Excel - "Refusing to run query with no limit that Looker cannot stream incrementally."
I regularly download data from a Look (Excel format, With visualization options applied, Formatted, All Result...
Limit Displayed Columns
Can we limit the number of displayed columns as we do for displayed rows like in this screenshot?I dont mean t...
Time filter on table, can some columns (measure) be time sensitive some not
Hi I am trying to create a single table in looker where some of the measures are adjusted with a page date fil...
Display all results even if value is null
Hi,I’m using visualization and I have an issue with some products which are hidden some days because there wer...
Can't fill in missing dates on merged table because: "Missing values can only be added for queries with one dimension"
Is there no way to fill in missing dates on an explore before merging when I want to picot by another dimensio...
Merging cells in Looker
Is it possible to merge cells or rows in Looker dashboards like what we can do in Excel?
Sorting a Stacked Barchart
I am trying to sort the my chart so that the Red (disagree) is on the far left, then gray, then light to dark ...
Question about template and how to refresh data
Hi,I have a few question regarding looker studio.Is looker studio is suitable to create dashboard using real-t...
