SAP Knowledge Base Article - Public

3161198 - How do I get a distinct count of a field using SiGNAL?

Symptom

We are working on a PI investigation and wanted to know, is it possible to get distinct count of an Event level attribute using SiGNAL?


Resolution

To get the distinct values of an event level attribute you can write:

SELECT DISTINCT event_attribute
FROM FLATTEN(THIS_PROCESS)

The client will inject the chapter and widget filters into the correct place now.


Keywords

KBA , BPI-SIG-HUB , SAP Signavio Process Collaboration Hub , How To

Product

SAP Process Collaboration Hub by Signavio all versions