Were 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 didnt 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 were overlooking an easy route.
BTW: were on premise, version 4.5