Expand my Community achievements bar.

SOLVED

Agregate

Avatar

Level 2

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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