Segmentation by count

[gabrielf1]

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

[johnwwilcoxmba · Accepted solution]

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.

[gabrielf1]

It works! Thank you.

[gabrielf1]

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.