Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Segmentation by count

Avatar

Level 2

Hello,

 

please, I need to create one segmentation by number of rows. For example when I group the rows by ClientId, the Ids with only one row are one segment, the Ids with 2 rows are other segment and so on.

 

How could I create this segmentation? Could you help me, please?

 

Att.,

Gabriel

1 Accepted Solution

Avatar

Correct answer by
Level 6

Create a query say over the profile table, then use Additional Data to count the number of rows.  Then use Segmentation to analyze the count.

View solution in original post

3 Replies

Avatar

Correct answer by
Level 6

Create a query say over the profile table, then use Additional Data to count the number of rows.  Then use Segmentation to analyze the count.

Avatar

Level 2
Please, could you help me again? How can count the number of rows with a group by? I tried RowNum(PartitionBy(@IdCliente), OrderBy(@IdCliente)) but it doesn't works.