Filter for table

Technical Implementation Analysis
#1

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?

#2

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

#3

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

#4

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

#5

add screenshots
process

image
image658×625 37.6 KB

my table
image

kpi for table

image
image1006×202 42.6 KB

#6

Hi Artem,

I’m sure it’s 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 doesn’t 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

#7

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