Looker Aggregate query contained the following measures we cannot roll up

Hello Everyone,
I am rather new to Looker and am trying to setup an Aggregate Awareness to speed up some of our dashboards and am running into some issues I can’t get around.  

I’ve copied the aggregate tables from the “get look ml” in my explores and applied them to my model.  I have also turned on:  allow_approximate_optimization to the distinct_counts that are used in the tiles that will not aggregate.  

However, only 1 of my tiles gets all of it’s data from the aggregate table.  The other tiles are still telling me they can’t rollup some fields.  The fields that won’t aggregate all seem to use the distinct_count that i have turned on the approximate_optimization option for.  

Can someone point me to some steps I can take to troubleshoot this?  I found the below link but the two tiles that I am working on use the same join to the same date table.  So I would be surprised if the join is causing the issue.  Is there a way to tell for sure?

https://community.looker.com/lookml-5/aggregate-tables-and-symmetric-aggregation-23235
This contains the steps I used to create my aggregate awareness explores:

https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness#exact_match

Thanks for any help!

1 0 769
0 REPLIES 0
Top Labels in this Space
Top Solution Authors