Calling a value from a specific row using table calculations


(Zachary Michel) #1

A question I’m approached with frequently on chat is how can one reference a value from Column B given a specific value from Column A, i.e grabbing the count from a specific date regardless of that dates position in the table.

Here’s an example on learn.looker.com. See table calculation + screenshots below.

max(if(${orders.created_date} = "2015-08-22", ${orders.count}, null))