Skip to main content

Good afternoon -

I am currently working on transitioning all of our old Looker dashboards into the new format. After running some of the new queries, I’m noticing a field being returned at the top of the result set called “preview”. I’ve tried a few ways of excluding this field (jncluding AND principal.location.country_or_region != "preview" nocase). Nothing seems to be working to get rid of this entry.

Any suggestions?

I figured it out -- this is just an empty field and can be excluded simply through principal.location.country_or_region != ""


What if you wanted to include the results that have that empty field though?


@jdavisson_CYD in my case, I would just leave out the principal.location.country_or_region != "" string if I wanted to see the blank fields in my search. 


right, but the blank field still display “preview” instead of an actual blank


@jdavisson_CYD I see what you’re saying -- good question -- i’m not entirely sure. I’m Mmessing around with the data again today and will let you know if I come up with a solution.