Aggregate awareness exact match

  • 17 January 2022
  • 0 replies

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.

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.

Appreciate your guidance and suggestions.

This topic has been closed for comments