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”) ))