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
Page 1 / 1
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 :
https://**Your-Instance.Your-Cluster.**celonis.cloud/help/display/CIBC/KPI+Saved+Formulas
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 didnt know how to identify them:) Simple didnt come to my mind yet:) Huge thanks, now it works as I wanted!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.