Hello Celonis community,
I would like to create a bar chart with a trendline.
Is there something similar to the excel trendline option?
image.png335628 13.5 KB
Thanks in advance for your support.
Kind regards,
Francesca
Page 1 / 1
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):
With the moving sum formula you get a trendline based on the current value and the value before.
Hope this helps.
Best regards,
Bene
You could do the following to get a trendline in Celonis (In this example the Column Chart shows the Case Count per month):
- Set up a new Column Chart and add a Dimension (e.g. ROUND_MONTH(EKKO.AEDAT))
- Then you can set up the KPI you want to have in the chart (e.g. Case-Count: COUNT_TABLE(EKPO))
- 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)
- Go to the Component settings and choose Data Series: Trendline (or how you named the second KPI)
- 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
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?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.