Understand the pie chart

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

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

Thank you so much!! By this moment I already realized that it is something with the NULL values, but I didn’t know how to identify them:) Simple ‘’ didn’t come to my mind yet:) Huge thanks, now it works as I wanted!