Calculate touchpoints | Community
Skip to main content
L
LAR1985
Level 3
December 14, 2022
Solved

Calculate touchpoints

  • December 14, 2022
  • 1 reply
  • 1264 views

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

    Best answer by SatheeskannaK

    Hi @lar1985,

     

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

    Result:

     

    Thanks!

    1 reply

    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity AdvisorAccepted solution
    Community Advisor
    December 14, 2022

    Hi @lar1985,

     

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

    Result:

     

    Thanks!

    Thanks, Sathees
      L
      LAR1985Author
      Level 3
      December 15, 2022

      Thanks!! That has worked perfectly

      Terms & ConditionsAccessibility statement

      Loading footer...