Calculate touchpoints | Community
Skip to main content
Level 3
Dec 14, 2022 12:10 PM UTC
Solved

Calculate touchpoints

Hi all,

 

In a workflow, we want to get the touchpoints of each profile to insert in a custom resource that we have created. We have tried creating a additional field in a query acivity, counting the delivery logs, with the following function "Count(logs)", but we get the following error "PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions"

 

Do you know how can we do it?

 

Thanks

SatheeskannaK
SatheeskannaKAccepted solution
Level 1
Dec 14, 2022 2:52 PM UTC

Hi @lar1985,

 

Try with type aggregate on additional data in query activity to count the deliveries received.

Result:

 

Thanks!

Thanks, Sathees

2 replies

SatheeskannaK
SatheeskannaKAccepted solution
Level 1
Dec 14, 2022 2:52 PM UTC

Hi @lar1985,

 

Try with type aggregate on additional data in query activity to count the deliveries received.

Result:

 

Thanks!

Translate
Thanks, Sathees
LAR1985Author
Level 3
Dec 15, 2022 9:45 AM UTC

Thanks!! That has worked perfectly

Translate