Hi all,I've a blended data whose joint dimensions are date, media source and OS as seen below:I'm using the media source field with Coalesce formula, returning the notnull values only:However, when I use the same formula for a dropdown control (filte...

Hi,I am trying to run the following query but BigQuery shows an error: PARTITION BY expression references column date which is neither grouped nor aggregated SELECT EXTRACT(MONTH FROM date) month, country_name, SUM(installs), DENSE_RANK() OVER(PARTIT...