Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need Count based on group

Peace_B1
6 - Meteoroid

Looking to have another column with consective counts for each record based on the ID group.

For instance, Row 1 (A29GFL) would be 1, Row 2 would be 2, Row 3 would be 1.

 

The count is all based on location, so the first time an ID appears would be 1, the 2nd time it appears would be 2 etc...

Peace_B1_1-1608064001750.png

 

 

3 REPLIES 3

Hi @Peace_B1 

 

Please check the below. Cheers!

 

christine_assaad_0-1608067131354.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Peace_B1 
I also agree that Tile Tool is best fit in this situation.

Just for better understanding, here is a different approach.

1216- Peace_B1.PNG

Tyro_abc
11 - Bolide

Hi @Peace_B1 

You can do this using 'Running total' very easily!

arundhuti726_0-1608152855280.png

 

Labels