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

Adding a dimension to the explore shows "No Results?" What is happening?

Knowledge Drop

Last tested: Jul 12, 2017

One potential reason is that you are attempting to filter on a Measure. Adding a Filter on a Measure does not add a WHERE statement but instead adds a HAVING statement. That means that the behaviour of a measure filter changes depending on the grouping.

For example, say you filter on "count = 2". Then you group by user and find that there are several users with a count of 2. Then you remove the grouping and get "no results". The reason for this is that the count is now one large number, and that number is not 2.

So what could you do? There is hope! You can Dimensionalize a Measure!

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 12:45 PM
Updated by: