Aggregate awareness exact match

Hello all, 

I have order_item Explore with the below joins:

order_item ----- (many-to-one) ----- order ----- (one-to-many) ----- tender


I am trying to create an aggregate table which would include measures from order_item and tender.
My aggregate table is not used due to the joins cardinalities if I understand the documentation correctly. https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness#symmetric_aggregates_for_e...

I am trying to get around this by creating an exact match using an Explore query but I am not sure how to achieve that correctly. I got the LookML from my explore query and created a persistent derived table with it, and then … ? I am not sure how to do this correctly.
https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness#exact_match

Appreciate your guidance and suggestions.

0 0 93
0 REPLIES 0
Top Labels in this Space
Top Solution Authors