SIGNAL query - table with counts and proportions

[vp_nbn]

Hi all,
I would appreciate your help.
I have a SIGNAL widget which presents counts of which event happens first:

SELECT
"First Call",
COUNT(CASE_ID) AS "No. of Cases"
FROM
(SELECT DISTINCT
  CASE_ID,  
  FIRST(EVENT_NAME) OVER (PARTITION BY CASE_ID ORDER BY END_TIME) AS "First Call"
FROM
FLATTEN(THIS_PROCESS)
ORDER BY 1) AS SUB
ORDER BY 2 DESC

I'd like to add another column to the table, in which the proportion of each row/ event.

I was hoping this group might help with this and look forward to hearing from you. Thanks.

Kind regards,

Vladimir

[Taleh_Khalili]

Hi Vladimir,

Thanks for your question.

This documentation about the SIGNAL - SIGNAL Cookbook | SAP Help Portal - should provide insights about the topic. Please let us know if it does not help. Thanks!

Kind regards,
Taleh