KPI("Number of process variants")
versus
COUNT(
DISTINCT
VARIANT(
"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"
)
)
image.png900323 21.4 KB
Im having some trouble understanding how the built-in Number of process variants KPI is calculated. I dont understand why these two statements are not equivalent.
versus
image.png900323 21.4 KB
versus
image.png900323 21.4 KB
Page 1 / 1
Hi,
the reason for this is that the Number of process variants saved formula uses the following formula:
A->B->B->B->C and A->B->B->B->B->B->C, they are both shortened to A->B->B->C.
This is why your number without the SHORTENED is larger.
Cheers
David
the reason for this is that the Number of process variants saved formula uses the following formula:
COUNT(
DISTINCT
SHORTENED(VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"))
)
SHORTENED reduces the cycle length to 2. So if you have variantsA->B->B->B->C and A->B->B->B->B->B->C, they are both shortened to A->B->B->C.
This is why your number without the SHORTENED is larger.
Cheers
David
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.