Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

Can you do a measure type: yesno?

Knowledge Drop

Last tested: Jul 24, 2020

Yes you can!

You can create yesno measures the same way that you create yesno dimensions. See

When you filter on them, they go in the HAVING clause instead of the WHERE clause.

However, don't use them in filtered measures. You can only filter on dimensions in filtered measures.

Also, make sure they only reference other measures.

Tip: to create a yesno measure from a yesno dimension (in this example, it's "yes" if any dimension value is yes), we can use something like this:

measure : was_live

type: yesno

sql: sum(case when ${is_live} then 1 else 0 end) > 0 ;;

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 03:15 PM
Updated by: