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 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 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.