Expand my Community achievements bar.

SOLVED

Calculate touchpoints

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @LAR1985,

 

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

SatheeskannaK_0-1671029419865.png

SatheeskannaK_1-1671029446169.png

SatheeskannaK_2-1671029461167.png

Result:

SatheeskannaK_3-1671029535031.png

 

Thanks!

Thanks, Sathees

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @LAR1985,

 

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

SatheeskannaK_0-1671029419865.png

SatheeskannaK_1-1671029446169.png

SatheeskannaK_2-1671029461167.png

Result:

SatheeskannaK_3-1671029535031.png

 

Thanks!

Thanks, Sathees