Skip to main content
Solved

Aggregating the data by mapping property

  • April 28, 2025
  • 2 replies
  • 77 views
Chahat
Master Helper
Forum|alt.badge.img+14

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
 


 

Best answer by Chahat

 ​@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:

test1[REMOVE SUM: Quarter][by : 'personalised quarter'.MapQ]

 

2 replies

Min Li
Master Helper
Forum|alt.badge.img+12
  • Min LiMaster Helper
  • Master Helper
  • April 28, 2025

​@pigment_enthusiast Can you try either:

Test1[remove: ‘Personalized quarter’]

or test[by sum: ‘Personalized quarter’->‘Personalised quarter’.mapQ]

Min Li
Chahat
Master Helper
Forum|alt.badge.img+14
  • ChahatMaster Helper
  • Author
  • Master Helper
  • Answer
  • May 2, 2025

 ​@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:

test1[REMOVE SUM: Quarter][by : 'personalised quarter'.MapQ]

 

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement