How to add a Trendline

Hi Francesca, You could do the following to get a trendline in Celonis (In this example the Column Chart shows the Case Count per month):

1. Set up a new Column Chart and add a Dimension (e.g. ROUND_MONTH(EKKO.AEDAT))
2. Then you can set up the KPI you want to have in the chart (e.g. Case-Count: COUNT_TABLE(EKPO))
3. Then set up another KPI with the following formular (call it Trendline): MOVING_AVG( Here stands your KPI from above, in this example: COUNT_TABLE(EKPO) ,-1,1)
4. Go to the Component settings and choose Data Series: Trendline (or how you named the second KPI)
5. Scroll down and change the axis to secondary axis and choose line chart as chart type

With the moving sum formula you get a trendline based on the current value and the value before. Hope this helps. Best regards, Bene

thanks Bene. The formula works now I need to understand what time-windows is most suitable for my case. Cheers, Francesca

I would like to add a KPI to a OLAP Table. This should show the gradient, positive or negative, of the moving average trendline.

I would like to add a KPI to a OLAP Table. This should show the gradient, positive or negative, of the moving average trendline. @Bene could you help here?