Source metric: ‘test’ is having dimensionality City, Category, Personalized quarter, quarter
Target metric: ‘test2’ is having dimensionality: City, Category, quarter
Target metric formula is:
test[BY SUM: ‘Personalised quarter’.mapQ]For Fruityburg city, Q1 2024 → it should return 1790, but it’s giving 100
Test1[remove: ‘Personalized quarter’]
or test[by sum: ‘Personalized quarter’->‘Personalised quarter’.mapQ]
I had tried some other approach and it worked as expected.
Here’s the solution:
test1[REMOVE SUM: Quarter][by : 'personalised quarter'.MapQ]
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.