Calculate Standard Deviation and Percentiles by Country
How can I get a table where I can see the country code, the count of accounts created and the standard deviati...
Forum Posts
Percent change and difference
Hello! I created a custom filter to calculate transactions in last month and same month last year (year over y...
Calculated Field with IF statements
I am trying to create a calculated filed based on an if statement to categorize and add the sales in Looker. I...
Looker expression editor _ subtraction by pivot rows (sum by grouped dimensions, then subtract)
Hi,I am new to Looker, not sure if it is possible using Looker expression editor to achieve this (I cannot use...
Filtering on Table Calculations
I’m sure there is a technical or performance reason I’m overlooking but why doesn’t Looker allow filtering on ...
Percentage of Text Value in Pivot Table
Hi!I'm having a hard time getting pivot tables in Looker to show some data. My Google sheets data has only tex...
linking of drill downs of two tables
Is linking of drill downs of two tables (With same dimensions) in Looker Studio possible?
Calculated Percentage in Total Row
Hello,I was wondering how to or if there is a workaround to a calculated field that is then displayed in the t...
Looker Categorical Statistics
I have to generate a report of invoices in Looker. Each invoice belongs to a category field. I am tasked with ...
How can I create a dimension that captures if all entries in a column of are completed?
Hi! The title is a bit confusing, so I will put an example here:I have a survey that gets sent out to Users. I...
Calculated fields from Google Sheets
I have my report linked to a google sheet and I created a new field with a simple formula to add several colum...
How do I concatenate 2 dollar columns and preserve dollar formatting.
Hello. Lets say I have 2 columns with the following dollar amounts - $250,294 and $717,543How do I concatenate...
How to determine the minimum or maximum date with table calculations
Authors: The Looker Team The problemWe want to find the minimum or maximum date in our Explore results, but th...
Create Table Calculation
I need use the function offset, but i can’t find the option add -» Calculation_-» Table Calculation in this ve...
Weighted Average of three calculation totals in a dashboard
Hi, I am stuck with a relatively simple issue. Nevertheless, I have the feeling that the solution might be qui...
How do i split each column with comma separated values into multiple rows in looker explore
In my visualization in looker dashboard tile explore, i have one column, some with empty values and others wit...
How to group aggregate values into buckets?
I have a google sheet full of donation transactions like thisname, date, amountAnd I built a simple Looker tab...
How to convert currencies from euro and usd to pln?
Hi.I need to convert multi currencies from EUR and USD to pln. Data are in table. For example first row is in ...
Plot only a table calculation in visualization?
Hello everyone,I have a Looker tile which is a table, and I’m currently doing a Table Calculation to determine...
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...
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...
Z-Test Execution
Hello everybody,Currently we have been trying to execute the z_test(data, value, stdev) function based on a bu...
Calculating annualized attrition
How to create a calculated field for “Annualized Attrition” in Looker Studio. Any help will be highly apprecia...
Combining data from multiple tables in a new table
Hi all,I’m having to use a filter on Conversion Type Name to separate some offline conversions vs general conv...
Subtracting two date time
Hi everyone I got an issue, How can I subtract the arrival and depart (date_time) in to deviation (hours) and ...
Custom filter on two measures
Hi,I have 2 measures (agg.x and agg.y). I only want to display the rows where agg.x > 0 OR agg.y > 0. I did th...
Multiple data points in a single cell
I have a table on a dashboard that shows the amount of marketing spend along with various performance metrics ...
How do I count only non- null values in a row in table calculation
I have a row of data with some null values, I just want to count the times that the value is not null. Is ther...
Rank with a Filter (table calculation)
I have a list of SKUs, the Product Category each SKU belongs in, and each SKU’s Order Count. I’d like to make ...
How do I get a column total that doesn't change with filtering?
For example, let’s say I have list of retailers and the revenue numbers for each.If I filter the list to show ...