Hi,

I am trying to filter the data using CASE WHEN statement in the component filter section but it is not working.

Scenario: when DATE_1 is not NULL then show data only till yesterday using DATE_1 (DATE_1 < TODAY()) else show data till yesterday using DATE_2 (DATE_2 < TODAY()).

This works file if I execute single statement like FILTER DATE_1 < TODAY() but it is not working when I combine into CASE WHEN like below:

FILTER CASE WHEN

ISNULL(DATE_1)=0 THEN DATE_1 < TODAY()

ELSE

DATE_2 < TODAY();

Any help is really appreciated.

Note: We are using Celonis on-prem 4.5