Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Agregate

Avatar

Avatar
Validate 1
Level 1
Ghanname
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
Ghanname
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Ghanname
Level 1

28-09-2020

Hi, 

I have a table with three columns Email, score and event and I wanna have the sum of the score by event for each profile lets take an exemplep profile X have two three events Open two times with a score of 2  and video view one time with a score 5 I want to have only email total score for open which is 4 and the second score of 5 with a video view as an event nameso for each profil I will have the sum for every label seperatly.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

266 likes

Total Posts

392 posts

Correct Reply

192 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

29-09-2020

You should be able to do so using a workflow though it may look a bit complex:

  • Fetch all records from the table
  • Do a fork
  • Do an Enrichment and join both parts of the fork
  • In the enrichment join the data using a N complexity join on Email + Event
  • In Additional data, add the result of the query and choose aggregates
  • Here you now can define Sum on the score column

That should aggregate the data accordingly

Answers (0)