Skip to main content
Hello, my KPI with Parameter does not work in View Tables. I get an error message: Wrong syntax for KPI parameter id. I used the code snippet which worked in the kpi list for the same parameter.

Are you sending the parameter with the correct ID and Display Name from the View as well ?

 

Kindly look at the following imageimage 


Hi Abhishek,

yes, I used the variable with the parameter in a kpi list and copied the snippet, so i don't no why it is not working in tables.


Working in KPI list

working in kpi list


not working in table

not working in table


error

error


I was just going through the documentation, seems there is no kpiParams section in the Attribute could be an indication of this not being allowed in a table. I am not sure about this would suggest you to raise a ticket with Celonis.


okay, thank you.

Do you know if there is another way to use KPIs in tables that depend on a variable from a dropdown? I want to calculate the ratio of the activity I selected in the dropdown.


okay, thank you.

Do you know if there is another way to use KPIs in tables that depend on a variable from a dropdown? I want to calculate the ratio of the activity I selected in the dropdown.

Hi Lukas, the way I would go about doing this is by creating an Attribute and using it with the variable i.e when I click on the dropdown my attribute column is updated into the variable. Assume your Record is ACTIVITY and your attribute is RATIO. When I select the dropdown, the variable should be updated to RATIO. Now I can just change my field as below to make it dynamic (${dropdown} is my variable)

 

 - field: ACTIVITY.${dropdown}


Hi Lukas, the way I would go about doing this is by creating an Attribute and using it with the variable i.e when I click on the dropdown my attribute column is updated into the variable. Assume your Record is ACTIVITY and your attribute is RATIO. When I select the dropdown, the variable should be updated to RATIO. Now I can just change my field as below to make it dynamic (${dropdown} is my variable)

 

 - field: ACTIVITY.${dropdown}

PS: You should be able to do the same with KPI, just update the variable with the KPI id


Hi, what do you mean with attribute in this context? I dont know if I understand it correctly.


Hi,

I was facing the same issue and received an answer from Celonis:

Currently, it only works if the KPI Parameters are also named p1, p2, p3 (as in the PQL statement), i.e. in the KM, you have to put p1 in the id field and then reference it with p1 in the table. Also, as far as I understood from the answer, you cannot use the same KPI multiple times in the table with different parameter values as it will always use the first set of values.


Reply