Knowledge Drop

Can you reference measures in custom filters?


Userlevel 5

Last tested: Jan 12, 2021
 

Nope. Our docs mention this here: https://docs.looker.com/exploring-data/filtering-and-limiting#custom-filters 
There is a feature request for this though, please comment!

 

There is an easy workaround, using a LookML measure type: yesno like so:

measure: testyn {

type: yesno

sql: ${count}<> value or ${users.count} <> 1;;

}

You can then filter on this yesno measure in the explore.

 

This content is subject to limited support.                

 

 

 


0 replies

Be the first to reply!

Reply