Hi Artem,
you can simply put the condition of the CASE WHEN inside a FILTER statement:
FILTER PROCESS EQUALS '' END;
Also check out the Documentation of PROCESS EQUALS or FILTER for some more examples.
Best
David

---

but in this case all my counts of the number of acquired statuses are zero
kpi code:
COUNT (CASE WHEN DOCS_EVENTS_TABLE_PROC_RESULT. EVENT LIKE Agreed by the SSC Contract Department
THEN DOCS_EVENTS_TABLE_PROC_RESULT. BARCODE ELSE null END)
+
COUNT (CASE WHEN DOCS_EVENTS_TABLE_PROC_RESULT. EVENT LIKE Rejected SSC Contract Department
THEN DOCS_EVENTS_TABLE_PROC_RESULT. BARCODE ELSE null END)
+
COUNT (CASE WHEN DOCS_EVENTS_TABLE_PROC_RESULT. EVENT LIKE Requested documents and information SSC contract department
THEN DOCS_EVENTS_TABLE_PROC_RESULT. BARCODE ELSE null END)
+
COUNT (CASE WHEN DOCS_EVENTS_TABLE_PROC_RESULT. EVENT LIKE Sent for revision Contract department of the SSC
THEN DOCS_EVENTS_TABLE_PROC_RESULT. BARCODE ELSE null END)
this is the counting of certain events within one case id

---

Hi,
remember the filter filters on the deleted documents. So maybe there is no document where a condition in your KPI is fulfilled? Do you get a different result when you add the CASE WHEN of your original post to a OLAP table component and then click on a document deleted value to filter on the deleted cases?
If you want to filter on the valid documents, you can use
FILTER PROCESS NOT EQUALS '' END;
Cheers
David

---

add screenshots
process
image658625 37.6 KB
my table

kpi for table
image1006202 42.6 KB

---

Hi Artem,
Im sure its not related to the filter. Can you please check the following things:

• put the CASE WHENs of your KPI inside separate dimensions of an OLAP table (without the COUNTs around them), along with the EVENT and BARCODE columns, to see if the CASE WHENs produce results which are not null. If you can only see null results, the condition evaluates to false for some reason.
• Try = instead of LIKE in the CASE WHEN conditions.

If that doesnt provide any insights, please open a ticket at our service desk. You can create a ticket via https://servicedesk.celonis.com or e-mail to servicedesk@celonis.com. In that case, please also specify the Celonis version you are using (from your screenshots it looks like you are on an rather old on-prem version, is that correct?)
Thanks and BR
David

---

Hi!
ok, i will open ticket
Yes, we use on-prem version 4.3.0-RELEASE_109c2c74d2_20180306_1857

---