Question

Aggregate awareness exact match

  • 17 January 2022
  • 0 replies
  • 31 views

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_explores_with_joins

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.


This topic has been closed for comments