Agregate | Community
Skip to main content
G
Ghanname
Level 2
September 28, 2020
Solved

Agregate

  • September 28, 2020
  • 1 reply
  • 1228 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by bisswang

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

1 reply

B
Adobe Employee
bisswangAdobe EmployeeAccepted solution
Adobe Employee
September 29, 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

    Terms & ConditionsAccessibility statement

    Loading footer...