Hi @tjain02 ,
The second part will be mapped to the “Local” item in the Conversion dimension because of this piece of formula:
rby sum : Conversion."Local"]
Hope this helps,
Hey @Stef ,
My confusion is regarding the ‘+” operator. Wouldn’t that be used for summing values? Here in this context it seems it is being used to separate values based of different list items
Hi @tjain02 ,
I see. Imagine you would have three separate metrics:
Metric A:
'FX_01_Calc_FX Rates Staging'iADD constant: Version] o by sum : Conversion."Group"]
Metric B:
1rADD constant: Month, Currency, Version] iby sum : Conversion."Local"]
Metric C:
(A+B) Afilter:'Set_Filter_Version Window']
In metric C you would get the same result as in your combined formula. The + operator indeed sums the values but because they are both allocated by another item of the Conversion dimension you would never see the sum unless you’re looking at “Local” + “Group” (which does not make sense).
Hope this helps,
Hey @Stef , thanks for explaining it in this way. Makes sense now.