Is there a Table Calc function that lets me reference a specific row value (row index)?

LookerExperts April 5, 2021, 4:10pm 1

Knowledge Drop

Last Tested: Jan 21, 2019

Yes!

index(expression, n) will return the “Nth” row defined by the expression.

Topic	Replies	Views
Table calculation to create descending row numbers Technical Tips & Tricks exploring-data	11	June 28, 2021
Can I use Table Calcs to find the total number of rows in my result set? (max) Technical Tips & Tricks exploring-data	1	April 5, 2021
In a table calculation, how do I fill all of the null values of a column with the last non-null value of that column before the current row? Technical Tips & Tricks	36	April 5, 2021