Skip to main content
Hello! How can I put similar filter on a table? In KPI, I would write it in this way: CASE WHEN PROCESS EQUALS END THEN document deleted ELSE valid document END (means = Deleted) but how do you write it as a filter?
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