Hi Patrick,
This is an odd behavior. It could be caused by misleading CASE WHEN / ELSE results.
Celonis has just released a more adherent CASE WHEN logic (similar to SQL) to handle the NULLs
"When using an ELSE fallback condition, so far the rows evaluating to NULL would be returned as NULL even if the ELSE statement was correctly defined. Example, when <COLUMN> = ‘A’ evaluates to NULL, then the following statement
CASE
WHEN <COLUMN> = ‘A’ THEN ‘option A’
ELSE ‘other’
END
returns NULL instead of ‘other’. This counterintuitive behavior will change: CASE WHEN will return ‘other’ with NULL inputs. This will lead to less NULL results and more ELSE results if NULL values are input values, and if ELSE is being used. If no ELSE is defined or if ELSE NULL is used, the result will still be NULL and nothing will change. "
Unfortunately, this is only available in the EMS (Cloud version) and not on the Onprem as you mentioned
Great to hear you've adjusted the behavior. While not 100% technological logically, it is more of a user expected behavior.
thank you for informing me !