Grouping of event in SAP Signavio Process intelligence

[ShubhamGuptaGenpact]

Hi Team,

I working on the dashboard for case-centric process mining. There is one simple outcome that I am trying to populate in the form of table.

"Activities and their respective count"

When I run the signal query "select event_name, count(*) as Numberoftimes from THIS_PROCESS. There is an outcome and it is not what I expect. I expect Activity table to have distinct activities and the count table to show respective counts. Example : Order cretated  - 32, Create Invoice - 45 likewise for all the activities.   However the output is different, the activities are grouped and they come in different combinations format.  Example : Create Sales Order, Create Invoice, Clear invoice  will have one group and their respective count as xx(any number) . Then again Create Sales Order will come in another group with different combination. Can anyone please advise why this grouping takes place and If i want to have the outcome as stated above. What i can do. Thank you

[Samuel_Gosling_Product_at_SAP · Accepted solution]

Hello there, 

The behaviour that you are experiencing is expected, as you are querying from THIS_PROCESS. This table stores cases as unique rows, and within each case row nests the respective events and event attributes. See this help page for a better overview: https://help.sap.com/docs/signavio-process-intelligence/signal-guide/intro?locale=en-US&q=SIGNAL 

Solution
To achieve your desired outcome, you should "flatten" the table, which un-nests the table and allows the table to be distinct by the case id and the event information. See more information about the FLATTEN operator here: https://help.sap.com/docs/signavio-process-intelligence/signal-guide/flatten-operator?locale=en-US&q...

Therefore, you could achieve your desired outcome by changing your FROM to the following:

FROM FLATTEN(THIS_PROCESS)

[ShubhamGuptaGenpact · Accepted solution]

Thank you goslingsam for your response. It worked.