3580367 - Creating a Ratio or Percentage column using SIGNAL Query in SAP Signavio Process Intelligence

• A need to create a SIGNAL query to find the ratio of a dimension example (payment method) to the total cases in SAP Signavio Process Intelligence.
• The aim is to represent this ratio in a Table widget.

Investigations for SAP Signavio Process Intelligence

1. Open SAP Signavio Process Intelligence.
2. Navigate to the Processes section.
3. Attempt to write a SIGNAL query to find the ratio of each payment method to the total cases.

1. Navigate to the Processes section in SAP Signavio Process Intelligence.
2. Use the SIGNAL WINDOW functions to create a query.
3. The SIGNAL code should be structured as follows:

SELECT DISTINCT "payment Method",

COUNT("CASE_ID") OVER(PARTITION BY "payment Method") AS "Cases per method",

COUNT("CASE_ID") OVER(PARTITION BY "payment Method") * 100 / COUNT("CASE_ID") OVER() AS "Percentage (%)"

FROM THIS_PROCESS

ORDER BY 1

1. Test the SIGNAL code with your data.
2. If successful, the ratio of each payment method to the total cases will be represented in a Table widget.

• SIGNAL WINDOW functions

SAP Signavio Process Intelligence, SIGNAL query, ratio, payment method, table widget, case level attribute, processes, investigations. , KBA , BPI-SIG-PI-INV , Investigations for SAP Signavio Process Intelligence , BPI-SIG-PI-SIG , SiGNAL for SAP Signavio Process Intelligence , Problem