KPI("Number of process variants")
versus
COUNT(
DISTINCT
VARIANT(
"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"
)
)
image.png900323 21.4 KB
KPI("Number of process variants")
versus
COUNT(
DISTINCT
VARIANT(
"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"
)
)
image.png900323 21.4 KB
COUNT(
DISTINCT
SHORTENED(VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"))
)
SHORTENED
reduces the cycle length to 2. So if you have variants
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.