Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.