I need your help on one metric.
Some information :
TL_RBRA : Transaction list with all orders. “Order_id” is the primary key. There is a column “Brand_id”
TL_Brand_Type : Transaction list with all Brands. “Brand_id” is the primary key. There is a column “Brand_Type”
Gms_eur_without_vat = Gross Merchandise Value
In the transaction list “TL_RBRA”, I have two dimensions :
- “Month” with the colum “ts_checkout_payment_confirmed”
- “Country” with the “retailer_country”
I want to make this metric :
TL_RBRA.gms_eur_without_vat [by : TL_RBRA.ts_checkout_payment_confirmed.Month , TL_RBRA.retailer_country]
I want to add the dimension “Brand Type” in this metric but it is in the transaction list “TL_Brand_Type”.
I have a dimension “Brand_id” to make the link between these two transactions list. I don’t want to make a “Vlookup” to add “Brand Type” in “TL_RBRA” but make it directly in the metric.
Do you have the solution ?
Thanks a lot for your help.
Best answer by francoisView original