I have a time series plot of the automation rate like the following:
x- Axis: ROUND_MONTH(“EKKO”.“AEDAT”)
y-Axis: KPI(“Automation Rate”) (standard automation rate formula; should work then with any KPI)
My Goal is to calculate the difference in the automation rate between the current month and the previous one i.e. get as result 4.8%.
How to do this in celonis?
In the end I want to have a list of KPI’s which from design point of view look like the following
Is there a simple way to calculate the 4.8% in a dynamic way (the 7.33% is coming from 2 years of data)?
Thxs & Br,