Are you sending the parameter with the correct ID and Display Name from the View as well ?
Kindly look at the following image
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
not working in table
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.