Skip to main content

Hello,

I want to calculate a Number KPI that will return me an percentage value of the cases covered by the 5 most common variants. The code should be similar to the % of cases covered in the Variant Explorer, but will always select the 5 most common variants in respect to the selection.

Neither the Number of variants function nor the PQL references help me with my problem.

Can someone help me out?

Thanks in advance!

Hi Arne, This will be possible in the next couple of weeks in the IBC and with the next on-premise release which will be in the next couple of months. Kind regards, Max
Hello Max, Do you know if it now possible? I am also interested in such functionality. Regards Guillaume

Hi Guillaume,

you will need to use the INDEX_ORDER functionality. There is an example in the documentation that shows the solution to your problem. You can find it here:

help.celonis.cloud/help/display/CIBC/INDEX_ORDER

(You can find the example at the bottom of the page)

Cheers

David

Hi, I am interested too in such calculation. Could it be possible to show an example of INDEX_ORDER functionality? But I dont have an account for celonis.cloud. Thanks a lot

Hi Alexan,

the syntax of INDEX_ORDER looks like this:

INDEX_ORDER( column [, sorting ] [, GROUP( group_column, ... ) ] )

So given a column and an optional sorting (ASC or DESC), INDEX ORDER will index

the rows accordingly, starting with 1. With the grouping option, independent index order ranges will be created for each group, all starting from 1.

To try it out yourself and access the full documentation, you can simply sign up for Celonis Snap:

https://www.celonis.com/snap-signup

Cheers

David

Community Code of ConductAccessibility statement