Question
Filter for table
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?
+2Hi 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
Davidbut 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
+2Hi,
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
kpi for table
image1006202 42.6 KB+2Hi 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 ofLIKEin the CASE WHEN conditions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.