Question
Ranking the identical number as identical rank
Hi Community,
I am trying to make ranking olap table.
As rank, I use INDEX_ORDER() with desc tentatively, and it returns sequential numbers to identical values.
Id like rank like DBMSss rank function like in MSSQLServer or Orale that returns identital ranks to identical values.
image865452 16.6 KB
Is there any ways to do above?
Thank you,
Since the Screenshot is not displayed here I would suggest contacting our ServiceDesk regarding this topic.
Best
Kevin
+2Hello Takayoshi,
INDEX_ORDER unfortunately does not have the same behavior as RANK() in SQL Server
(The index column contains a unique integer value for every row).
this would be a good idea to submit to our Product (you can do it via servicedesk@celonis.com) or directly in Celopeers.
Best,
Gabriel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.