Hi everyone,
I am looking for help on how to add in my CMRA Recipe a formula that creates a new column with the total number of contacts per account ID.
This is possible through a Pivot tables when creating lens, but I would like to have that as a value in my output.
Accounts and Contacts will have the tables joined.
To add a new column with the total number of contacts per account ID in your CMRA recipe, ensure you have a join between the Accounts and Contacts tables. Add a Formula node after the join and use a formula like COUNT(Contacts.Id) AS Total_Contacts. Group by the Account ID to aggregate the count correctly. Make sure your output schema includes the Account ID and the Total_Contacts column, then run the recipe to generate the output with the contact totals.
