Use filter attribute to calculate user value
Hi everyone.One of the data columns that I need to display in looker is calculated using the end_date of the c...
Forum Posts
How to verify if 3 values from merged tables are the same?
Hello Guys,I have the table below and I want to check if the values from all 3 columns are equal-If true to di...
Total and Subtotal in Looker Explore
Hi All,I have a requirement, where I need to show Yield and in the totals i need to show weighted yield.Yield ...
Using selected columns of a Pivot in Table Calculations
I have a query result with a Pivot in it. The data looks as shown below: Pivoted DataI have Type_A to Type_F a...
Average ifs calculatoin
I am trying to do a table calculation which will average one column, based on a criteria in a row. In the belo...
How to exclude null values in running totals table calculation
Hi, I want to create a graph with cummulative values (running calculations):running_total(${X.amount})The prob...
Custom measure, does not contain "X" except before a cutoff number "X"
Hello, I am hoping someone can help me with this question. I want to create two custom measures and/or table c...
Issues filtering a plot with table calculation
I want to show the MoM and YoY for 2021 (vs 2020) in a graph. But when I filter the dataset from 2021-01 to no...
How to sort starting with the current month
When we sort chronologically - it starts with January - DecemberHow can we sort so that the first row is alway...
Calculated columns as X axis in Bar charts
When we create a calculated column that gives the sum with a condition, how can I show that on x axis in bar c...
Dynamic Output of growth with table calcs
I would like to calculate a table calculation that shows something like it follows:Subject 2017 Revenue Differ...
Does the t-test function in the table calculations return the p-value or the t-score?
Does the t-test function in the table calculations return the p-value or the t-score?
Dynamically Show/Hide Series in Visualization across multiple Looks
This seems like it should be relatively straightforward but every option I have tried has not panned out. I ha...
Percent of Total Ignoring Filters
What is the best method to find the percent of total sales while ignoring all filters except one (the date)?Fo...
Getting QoQ views on a transposed table
Hi all, I’m trying to create a column similar to the one on the right, QoQ. I have 10 metrics that I would lik...
Compare current hour Vs Yesterday same hour
Hello all,Please, I need support with this case:I try to compare current hour of today VS the same hour from y...
Getting the Nst element of a List String in Table Calculation
Hi guys,So, I’m having trouble splitting some lists of strings. Basically, what I want to do is, get a list of...
Using a lookup table or Case Statement in Custom Dimensions/Table Calculations
Hello Folks, I have the following requirement. I have a query result that is in this format: Month Number Land...
How to calculate Count and percent of the total?
Hello, How do I go about answering these questions in Looker? is there anyway to get the total count and perce...
Caculate daily average
Hello everyone.So I found this is a recurrent question here on Looker Community, but I simply cannot make it w...
% DIFF BETWEEN DATE Y AND DATE Y -1
Hello all,I was wondering how can I have a % difference between a metric shown on data range Y vs the prior da...
create simple case statement in custom dimension or table calculation.
Why is it so hard to write a simple case statement in custom dimension or table calculation. Can some one help...
Bucket Dimensions as a Custom Field
I am making a visualization of clients served by gender. We have X male clients, Y female clients, and a few t...
Exclude a measure from being filtered
I have a table calculation with a query like below:count_distinct user_id / total_number_of_usersBoth are basi...
Calc Field
The Table calc field right now exist as a col calc. Can we add a feature that will allow to also do row based ...
Dynamically Filtering of a pivot table
Hi everyone!“New-Looker” here.I have the following data: Month, Country, Amount of sales (generated per month)...
Percent of total for distinct values
Hi all,I am aware that lot of questions have been asked about % of total but I could not find the specific que...
How to create table calculation using pivoted measure data?
I’m relatively new to Looker, so this may be an incredibly simple ask, but how do you build your table calcula...
Create columns based on other columns with filters applied
Hello,I’m new on looker so please be understanding I’d like to create a dashboard representing a monthly rati...
Calculating the max date in a column
Hi All is there a way to calculate the maximum (last) date in a column? I was thinking something as simple as ...