group by email | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
ParthaSarathy
ParthaSarathyAccepted solution
New Participant
October 18, 2023

Hi @rbiri,

Query:

Fetch all recipients, Filter as, Primary key is not empty. 

Complementary information:

Add data > Data linked to the filtering dimension > Data of the filtring dimension >

Add:

@email

@consentTypeAttribute

count(@consentTypeAttribute)

Select 'Group' checkbox for email and consentTypeAttribute alone

In Advanced parameter, check 'Disable automatic adding of PK'

Now you will be getting the count

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
View reply

1 reply

ParthaSarathy
ParthaSarathyAccepted solution
New Participant
October 18, 2023

Hi @rbiri,

Query:

Fetch all recipients, Filter as, Primary key is not empty. 

Complementary information:

Add data > Data linked to the filtering dimension > Data of the filtring dimension >

Add:

@email

@consentTypeAttribute

count(@consentTypeAttribute)

Select 'Group' checkbox for email and consentTypeAttribute alone

In Advanced parameter, check 'Disable automatic adding of PK'

Now you will be getting the count

Translate
 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...