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.