Skip to main content
Solved

How to create a chart that compares the development of a single KPI with the past year?

  • November 4, 2024
  • 1 reply
  • 92 views

philipp.finze
Level 1
Forum|alt.badge.img

Dear fellow Celonis users,

 

I want to create a bar or line chart where I can compare the development of a KPI in the current and previous year.

I saw that somebody suggested to create a filter for the respective year. This might help to switch back and forth. However I want to show it simultaneously in one graph.

 

Appreciate any help.

Best answer by denis.pede12

Hi Philipp, I encountered the same problem a week ago and did the following workaround:

Result:

Approach:

I had to do it for a quite simple KPI and it worked for me. I could imagine that this approach does not work for all KPIs. However, feel free to give it a shot and let me know whether it worked for you!

 

Cheers

Denis 

1 reply

denis.pede12
Level 7
  • Level 7
  • Answer
  • November 7, 2024

Hi Philipp, I encountered the same problem a week ago and did the following workaround:

Result:

Approach:

I had to do it for a quite simple KPI and it worked for me. I could imagine that this approach does not work for all KPIs. However, feel free to give it a shot and let me know whether it worked for you!

 

Cheers

Denis