About robertcarr

robertcarr

Author: Rob Carr, Customer Engineer, Cloud BI Introduction Looker allows companies to leverage its governed and secure modeling layer to provide data within customer facing applications or portals. This can be an exciting way for Looker users to furt...

robertcarr

An explore user would not need to know this as symmetric aggregates in Looker avoid the fanout issue assuming the model is correctly set up by the developer. (https://cloud.google.com/looker/docs/best-practices/understanding-symmetric-aggregates).A F...

robertcarr

The issue with include_as_cte: yes would be that it's going to cause fanouts as you would have no way of controlling the granularity of the CTE i.e. users dimensions would be added on the fly based on their selections. I think the only way it would w...

robertcarr

Hi @daniel_zendesk , Thanks for the question. Would the 'More' bucket allow for this? If you edit a dashboard and drag the filters to the right you should be able to group and hide filters under the 'More' option. Regards,Rob

robertcarr

That makes sense. Maybe you could create multiple CTEs and inject them in with a similar approach as this: https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/Aggregate-Awareness-using-in-query/ta-p/587376 but again it's not extremely scala...

robertcarr

Hi folks,Thanks for the post. This sounds like a bug, I can't replicate it internally. Can you both raise a bug on this via a support ticket? They will be able to investigate further.Thanks,Rob

My Stats

robertcarr's Bio

Badges robertcarr Earned

Recent Activity

Creating a signed embedded Looker iFrame for testing

Re: Add 'include as CTE' boolean to joins

Re: Add 'include as CTE' boolean to joins

Re: Bring forward in-use conditions from grouped filters

Re: Add 'include as CTE' boolean to joins

Re: Bug: Filter does not clear if a listens to filter changes