Marcus_O_Hanlon: if(row()=1, (${order_items.total_gross_margin}/${day_of_month_1})*(${days_in_month}-${day_of_month_1}) ,0) Thanks Marcus! This have been really helpful. Manage to implement it successfully.

I don’t think there’s this feature but you can go around and do this! One article written by Looker staff, Zachary Michel, wrote a very detailed post regarding “Displaying values from other fields in the tooltip”. Check it out at Displaying values fr...

brecht: diff_days(to_date(“1899-12-30”), ${users.created_date}) This is amazing! Work like a charm. 

Hey, I totally understand where you’re coming from! The next best question will be how can I hide the dimension while using it to create the dashboard. As Looker don’t have that feature (or at least yet), the only solution is to create a folder to hi...

At this time date formatting, color formatting, and hexadecimal conversion are not supported in Looker table calculation. However, if you’re doing it on a graph, you can use %d%B%Y as the data type. You can read more about it at https://docs.looker.c<!-- -->...