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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Segmentation by count

gabrielf1
Level 2
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
johnwwilcoxmba
Correct answer by
Level 5
Level 5

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
johnwwilcoxmba
Correct answer by
Level 5
Level 5

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

gabrielf1
Level 2
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.