Creating a pie chart with over 50 rows using table calcs to create an "Other" bucket
It is sometimes the case that we need to create a pie chart, or any other chart that has row limits, but our r...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
In what timezone does the table calculation now() return?
Knowledge DropLast Tested: Jul 3, 2018In databases that support timezone conversion, now() returns the time in...
Why Doesn't My Table Calculation Work in My Visualization?
The ProblemThe data is set up how you would like, but when you select the visualization type, Looker says that...
Add a total's column to a stacked bar chart
Knowledge DropLast tested: Oct 14, 2020 Using Table Calculations, you can add a total column to a stacked bar ...
Window Functions in Looker
Knowledge DropLast tested: April 2021 How do I use window functions in Looker?Window functions are a very powe...
Rank across pivots with table calculations
Knowledge DropLast tested: Sep 29, 2019 We are able to create Rank across pivots with a number of table calcul...
how to return first row of data
The problemLet's say you have a table like so:And you want to return only the first row of data in a single co...
Can you add, edit, or update table calculations in Looks via the API?
Yes, you can update the query object associated with a Look. There's a property called dynamic_fields which yo...
How can I do a diff_weeks for table calculations?
Knowledge DropLast tested: Nov 29, 2019 There's no built-in diff_weeks function, so it's best to use a custom ...
Referencing the Quarter Timeframe in table calcs
Knowledge DropLast tested: Jun 25, 2020 Say you're using a quarter timeframe that results in 2020-Q2, for exam...
Why do my queries with table calcs have such a long post-process/unaccounted for time when downloading?
Knowledge DropLast tested: Jun 24, 2020 There could be a few reasons for this, first off table calcs operate o...
How can I find the the first non-null row for a column?
Knowledge DropLast tested: Nov 2, 2018 There are several methods mostly using the first_value() window functio...
Use Table Calculations to Capitalize First Letter of String (INITCAP)
Knowledge DropLast tested: Dec 13, 2019 Most SQL Dialects have a function like INITCAP() that automatically ca...
Table Calculation to Grab Value(s) Associated with Last Pivoted Column
Knowledge DropLast tested: May 27, 2020 TL;DR: index(pivot_row(pivot_column()), max(pivot_row(pivot_column()))...
Why are my drills on running_total showing only that row?
Knowledge DropLast tested: Aug 6, 2020 running_totals are post-generated after the query is run, and so when w...
Table calculation for time difference accounting for negatives
Knowledge DropLast tested: Jun 1, 2020 The general logic here is, if the time diff is negative, then build own...
Table calculation for pivot 'subtotal'
Knowledge DropLast tested: Apr 9, 2020 sum(pivot_row(if(${view_name.pivot_field} = 'condition', ${view_name.me...
Table calculation to create descending row numbers
Knowledge DropLast tested: Oct 16, 2020 Using the row() function will get you an ascending list of row numbers...
How to get single value viz to report last value of running total
Knowledge DropLast tested: Apr 8, 2020 Say you have a running total table calc on a dataset that's sorted by d...
Table calculation for time difference accounting for negatives
Knowledge DropLast tested: June 15, 2020 The general logic here is, if the time diff is negative, then build o...
Moving Averages in Table Calculations
Last tested: Sep 2020You can make a moving average of a value in Looker with this simple table calc using offs...
Why is my table calc not calculating properly in merged results?
Knowledge DropLast tested: Jun 18, 2018This may be due to ambiguous column names. IF several columns having th...
How do I get conditional/dynamic formatting on table calculations?
Knowledge DropLast tested: Sep 27, 2018 If you select the "Custom" option when choosing your table calc's form...
Combine multiple Line Items using Table Calculations
Knowledge DropLast tested: Apr 24, 2020 Usually, if I have a list of dimensions and measures, if I want to cha...
Table Calculation "Unknown constant for .."
Knowledge DropLast tested: Sep 21, 2020 The ProblemFor table calculations with if statements, the error unknow...
Can I use Table Calculations to show total number of days in a month?
Knowledge DropLast tested: Feb 18, 2018 Yes, we can do that in Table Calculations. Given a date dimension ${da...
Calculation references field "xx.xxx" not in query
Knowledge DropLast tested: Jul 6, 2018You've probably seen this in the content validator! This refers to a tab...
Does Looker have a Table Calc equivalent to R's pnorm() and qnorm() functions?
Knowledge DropLast tested: Jan 21, 2019According to the R documentation (from inputting >?pnorm in R Studio), ...
Why is my table calculation expression reporting an argument type must match error message?
Knowledge DropLast tested: Jan 21, 2019 This can happen when creating an IF( ) statement in Table Calculations...
CASE WHEN in table calcs
Knowledge DropLast Tested: March 22, 2021Though a case when in table calcs is currently a feature request (see...
