Skip to main content
Question

Understand the pie chart

  • September 7, 2020
  • 2 replies
  • 4 views
M
Level 5
Hi, I am trying to build a simple pie chart and am a bit puzzled by the results. As dimension I added the following statement: CASE WHEN VBAK.BSARK = DFUE THEN EDI ELSE NON-EDI END And as KPI: COUNT_TABLE(VBAK) So, I want to see a pie chart that will be divided into two parts based on the value in the field BSARK: part 1 - DFUE part 2 - anything else But for some reason the pie chart also has a 3rd part which has - value. How shall I understand it? thanks a lot for any advise

2 replies

kay.kaspe
Level 3
  • kay.kaspe
  • September 8, 2020
Good Morning Masha, These are the NULL values (You can find a short explanation here). You could try the following Count NULL values in VBAK.BSARK as NON-EDI. Dimension: CASE WHEN COALESCE (VBAK.BSARK, ) = DFUE THEN EDI ELSE NON-EDI END KPI: COUNT_TABLE(VBAK) Do not count NULL values at all Dimension: CASE WHEN COALESCE (VBAK.BSARK, ) = DFUE THEN EDI ELSE NON-EDI END KPI: KPI(Filtered count, ISNULL(VBAK.BSARK) = 0) Documentation for default saved formulas: Filtered count : COUNT ( CASE WHEN {p1} THEN 1.0 ELSE NULL END ) https://**Your-Instance.Your-Cluster.**celonis.cloud/help/display/CIBC/KPI+Saved+Formulas
M
Level 5
  • masha.galit
  • Author
  • Level 5
  • September 8, 2020
Thank you so much!! By this moment I already realized that it is something with the NULL values, but I didnt know how to identify them:) Simple didnt come to my mind yet:) Huge thanks, now it works as I wanted!
Community Code of ConductAccessibility statement