SIGNAL query issue - including event-level attribute

[vp_nbn]

SAP Signavio Process Intelligence

In a dashboard within SAP Signavio Process Intelligence, I want to calculate a proportion/ percentage of cases which include a specific activity ("TT Submitted") AND have one event-level attribute with the value NULL.

For a simpler version of the script (percentage of cases which include a specific activity) I use this script:

SELECT
(COUNT(case_id)
FILTER (WHERE (EVENT_NAME MATCHES ('TT Submitted'))))
/ COUNT(case_id)
* 100
FROM THIS_PROCESS

I would really appreciate help from the forum. Thanks.

Kind regards,

Vladimir

[JessicaK]

Hello, thank you for the question! In this case, please create a support case using SAP for Me (log in with S-User ID and password). Kind regards, Jessica

[umasaral]

Hi 

try this whether its fine.

SELECT
(COUNT(CASE WHEN EVENT_NAME = 'TT Submitted' AND appointmentid IS NULL THEN 1 END))
/ NULLIF(COUNT(case_id), 0) * 100 AS percentage
FROM THIS_PROCESS;

[vp_nbn]

Hi, unfortunately I get an error: Oops! Something went wrong The function "=" was called with the invalid argument types LIST_TEXT,TEXT

FYI, I tried using appointmentid without any quotes, as well as with single and double quotes. I always get the above error.