Calculating if it is the first occurrence of an event

[David_Wong]

You can try this:

TRANSACTION_NUMBER = rank([{CREATED_AT} ASC], [{USER_ID}, {TRANSACTION_TYPE}], PRE_AGG)

Then filter by TRANSACTION_TYPE = “Buy” and TRANSACTION_NUMBER = 1.