We’re trying to create a chart with a line per year (e.g. KPI x in 2019, 2018, etc.).
In Celonis this means adding one KPI per year. (if not, please advise how!)
How can we easily filter the data within a KPI definition, for instance like such (which didn’t work obviously):
FILTER YEAR(table.column) = 2019; KPI_X()
Our current approach is to extend KPI_X with a parameter (Year), which is used as a filter in a CASE WHEN statement within the KPI_X definition. However, it feels like a complex solution to a simple problem. Hence this ‘sanity check’ question, whether we’re overlooking an easy route.
BTW: we’re on premise, version 4.5