Knowledge Drop

Can you reference measures in custom filters?

Userlevel 5

Last tested: Jan 12, 2021

Nope. Our docs mention this here: 
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!