Skip to main content

Source metric: ‘test’ is having dimensionality City, Category, Personalized quarter, quarter

Target metric: ‘test2’ is having dimensionality: City, Category, quarter

Target metric formula is:

testcBY SUM: ‘Personalised quarter’.mapQ]

For Fruityburg city, Q1 2024 → it should return 1790, but it’s giving 100
 


 

@pigment_enthusiast Can you try either:

Test1sremove: ‘Personalized quarter’]

or testoby sum: ‘Personalized quarter’->‘Personalised quarter’.mapQ]


 ​@Min Li Bright Point Thank you for your response. However, this solution didn’t work.

I had tried some other approach and it worked as expected.
Here’s the solution:

test1dREMOVE SUM: Quarter]Qby : 'personalised quarter'.MapQ]

 


Reply