This video shows how you can use improvements to the Sort transform to rank data, including partitioned ranking.
Ranking is available from v1.35.0.
As always, Youtube likes and subscribes are much appreciated.