Nested if condition in filters

Hi ,
Can looker support nested If condition in custom filters. for example , if I have several categories of data to be displayed and only three of them are considered and I need to display these three and rest can fall into ‘Others’ bucket . I do not have permissions to edit LookML/Custom SQL so have to do this in my “look”.

something like :

if(cat = “A”,“A”,(if (cat = “B”,“B”,if(cat = “C”,“C”,“Other”) ))

0 6 14K
6 REPLIES 6
Top Labels in this Space