Drill Downs for Table Calculations
Hi all,I have a simple table calculation on a report and I would like to control the drill down. If it was a m...
Forum Posts
Max Date Time from Partitioned by Client
@izzymiller or anyone can you give some suggestion, if there is a simpler way to do it? We have clients, and d...
Split comma separated values in column and add it in a new column
I have a table where I created a measure SourceOrderTag which can have 2 values as you can see in the tableThe...
Line chart of weekly accumulative unique values
Lets say I have a data table like belowid uuid date 1 1 2023/04/04 2 2 2023/04/05 3 1 2023/04/11 4 3 2023/04/1...
Table Calculations without row limit
Hello,I have a sales table by seller. I want to calculate percent of sold quantity by each seller. But when i ...
Calculating average across two views in looker when dealing with timestamp difference
I am working with a data where I need to calculate the difference and average of when a user is created and co...
Find range (or Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Find range (Max value minus Min value) for each unique building
I’m trying to figure out how to create a field that calculates the range (max minus min) of average element sc...
Moving Averages as Measures
I’ve come up with a “hacky” solution to including Moving Average as Measures into existing Looker models descr...
stddev_pop producing incorrect results?
Hi,I’m trying to return the standard deviation of a dimensionalized measure in an NDT but am getting incorrect...
Apply different If arguments to totals
Hello smarter people than I,I hope that you are well today!Does anyone know if there is a way that I could cre...
Help using Case/when/then in custom field (dimension) with conditions relating to null values
We are using looker through Chrome River (Emburse Analytics) and trying to combine 3 fields into one. We have ...
How to add a YTD running total measure on a month report ?
I am trying to include in a report that contains data from previous month, a running total for the year. For e...
Can I do a calculation across multiple tables measures?
Hello Looker Community! I have a task to calculate a total measures across different tables.Im trying to do a ...
Grouping rows
Hello,I’m reaching out for some help on how to aggregate rows in order to correctly display them in a chart. I...
How do I return a null value for a negative number in my statement below
if(is_null(${orders.need_by_date}),diff_days(${orders.created_date},${receipts.receipt_created_date}),diff_day...
Table Calculation
How can I count the number of instances in a column and then have it all on one visual Currently using sum fun...
Creating if statement to get the time in-between two dates, but if the need by date is NULL then I want to use The create date
I have this so far. I want to find the number of days between the need by date and the receipt date, but if th...
How can I disable Total for some metrics?
Is it possible to not show any value on total for certain metrics? .I am not using table calculation.
3 month rolling COUNT using lookml
Does anyone know how can i get this ?I want to create rolling 3 month count of a measure .So basically if i wa...
Cannot view table calculations in custom viz
We have made a custom viz similar to the Single Value viz in looker. The Table Calculations are not visible in...
Open Rate/Click Rate
I am trying to calculate the open rate/click rate from a field called “actions”. Within the field “actions” I ...
Replace 0 with null on column
Hello,I am trying to change some zero values with null because they show on the graph and they look ugly. I ha...
How to compare current quarter to same quarter last year?
I’m trying to show how we are performing in this current quarter to the same quarter last year, but have not f...
Table Calculations in quickstart queries
Are there any plans to allow the query parameter (for quickstarts) to contain table calculations?
Subtracting Two Measures
I am simply trying to subtract two measures: Count of X - Count of Y? This is done easily with a table calcula...
Multiplication of rows
Hi,I want to group the data with couple of dimesion, as part of it i want to multiply the rows of a particular...
Count repeated values in a column
Hello!I wanna know if it is possible to calculate the number of occurrences of a repeated value in a column. F...
Aggregate strings in rows
Hello!I was hoping there was a way to build a table calculation(s) to aggregate rows into a single row. Exampl...
Create custom measure that shows future expected sales
Hi, I am very new to Looker and was wondering if someone could point me in the right direction.I need to creat...