Dear Celonis Community,
I am having trouble creating a bar chart which tracks the amount of unsend orders. I need to filter all cases which do not have the “Delivered” activity and at the same time, have a preferred delivery date < current date. I managed to write two seperate statements but get errors trying to combine both. Maybe somone can help.
SUM(CASE WHEN TO_TIMESTAMP(“CASES”.“Preferred_Delivery_Date”, ‘’) < HOUR_NOW(‘PST’) THEN 1.0 ELSE 0.0 END)