Numbering based on unique values

[Mkhomiak]

Hello

I have data with a list of dates sorted. How can I add a new column that would assign a number based on unique date. for example below. every time my date field would change the number would change with it. thank you so much in advance!

1/1/2022 1
1/1/2022 1
1/1/2022 1
1/1/2022 1
2/1/2022 2
3/1/2022 3
3/1/2022 3
3/1/2022 3
4/1/2022 4
4/1/2022 4
4/1/2022 4
4/1/2022 4
4/1/2022 4
4/1/2022 4
4/1/2022 4

[kboeckholt · Accepted solution]

Hi @Mkhomiak 

Try using the Tile tool and using the Tile_Num output.

Configuration:

Output:

[Mkhomiak]

 thank you so much for the quick and simple solution!