You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Bug: Selected fields without aliases in BQ autogenerate with f0_ which breaks Looker explores. This provides an error on the SQL page.
Feature Request: Custom Measures on number types can be controlled with prefixing the alias. For example,
SELECT avg(sale_price) as avg_sale_price FROM orders generates a type=Average SELECT min(sale_price) as min_sale_price FROM orders generates a type=Min SELECT max(sale_price) as max_sale_price FROM orders generates a type=Max SELECT median_sale_price FROM orders generates a type=Median
All other alias prefixes will still generate a type=Sum custom measure SELECT sum(sale_price) as total_sale_price FROM orders generates a type=Sum