Skip to main content
Question

Dear community,my question is related to "Views" in EMS:I'd like to combine two KPI within one component (bar chart).Issue: One KPI should show "Company - Total" and one "Company - Region XYZ".(See details)

  • September 30, 2022
  • 2 replies
  • 7 views

Intention is that region XYZ can compare itself with the development of the company in total. Challenge is, that if I filter on region XYZ the data in the component are limited to region XYZ, so KPI for "Company - Total" would show the same KPI as for region XYZ. Reason is clear: Data from other regions are excluded by using the filter on region XYZ.

Even if I include the selections into the PQL of the KPI - when using a filter data are somehow limited.combined_KPIWished solution:

How to keep one KPI untouched within one component while others should change based on filters? I can do it in seperate components by using component filters, but that's not the smartest solution I'd like to present in the view, isn't it?

2 replies

  • Level 9
  • October 4, 2022

Hey Thomas,

 

The global KPI should be made independent of selections made. Therefore, I would recommend the function GLOBAL(), have you looked into this?

 

https://docs.celonis.com/en/global.html

 

Kind regards,

Maurits


  • Author
  • Level 1
  • October 4, 2022

Hi, Maurits.

Thank you. I'll give it a try and let you know.

Tom