Looker Table Calculation - IF statement

Looker Q&A Looker
1

Hi all,

I m trying to add a table calculation using the If statement.

I have a column that displays the below

adriana_clinci_0-1691067473088.png
adriana_clinci_0-1691067473088.png159×372 5.7 KB

and I want to add an if statement that will show the following:

IF “Actual” then “No calculations required” , if “EstimatedBasedOnGlobal” then “The global brand results”, otherwise “The same market & same brand results”

How can I ass this as a table calculation?

Thank you!

2

Hi,

You should be able to create a custom dimension in the top left of the tables option, and then for the if statement:

if($table.columnname$ = “Actual”, “No Calcs. Req’d”, “The global brand resulst”)

This would work if you only have two outcomes for the column: Estimated Calculations Required.

1 Like