count repeated values to get sequential order of occurrences

[genghisk]

I am a basic user and only have limited access to create custom dimensions and table calculations. Would it be possible with LOOKER to create count order of occurrences?

I can achieve this in excel via COUNTIF($a$2:a2,a2)

I’m trying to replace a date dimension with with 1st occurrence, 2nd occurrence, etc.

example: https://i.stack.imgur.com/0RokE.png