Dear Celonis Community,
I’m trying to set up KPI Meters with a certain color mapping to visualize performance against targets and benchmarks.
Users can already define targets via a variable which is also possible to include in the color mapping.
We managed to create global benchmarks via a write back to a custom Celonis table.
Would there be a possibility to make these benchmarks a threshold?
I figured that PQL inside the color mapping does not work.
+5Hi
The visual mapping UI only takes static numbers or variables, it won't parse raw PQL. Since you already have the benchmarks in a custom table, you can get around this in a few ways.
First, create a KPI in your Knowledge Model with the PQL that pulls the benchmark from your custom table. Then create a View variable and use an input component (like a dropdown or button) to set it from that KPI value. Once it's stored in a variable, drop ${your_variable_name} into the threshold box the same way you're already doing with ${apr_target}.
Second, you can change your main KPI formula to output a ratio (Actual / Benchmark) and set a static threshold of 1 (= 100%). Cleanest approach if you don't need the raw benchmark number on the dashboard.
Third, write a CASE WHEN in your KPI that returns text categories (like 'On Track' or 'Critical') based on the benchmark comparison, then use Categorical color mapping to assign colors to those labels.
Hi Gagan,
thank you so much for your suggestions.
I would prefer the first option as we have the first threshold defined by a target already (i.e. 40% and benchmark being 65%).
I’m able to create the entry as a KPI with the command LAST(“xyz”.”abc”).
However when trying to use it in an input dropdown I’m getting an error.
From my understanding the prerequisite is that it’s no aggregation, which is a fact I can’t change.
I’ll keep looking for another solution.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.