Versions Compared

Old Version 2

changes.mady.by.user David Becher

Saved on

compared with

New Version Current

changes.mady.by.user David Becher

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Applies to:  
Status
colourGreen
titleCelonis 4.0
 
Status
colourGreen
titleCelonis 4.2
 
Status
colourGreen
titleCelonis 4.3
 
Status
colourGreen
titleCelonis 4.4
 
Status
colourGreen
titleCelonis 4.5
 

Description

Process functions perform calculations based on the Case-Id and the Activity column of the event log.

While the Case-Id column is determined by the settings in the Data Model editor, the Activity column can be chosen freely for most process functions. The Activity column can also be preprocessed with other functions. For example with REMAP_VALUES, grouping and hiding of activities can be achieved.

Grouping

Example


Panel
borderColorgrey
Section
REMAP_VALUES groups B and C by mapping both to the same activity label.

Section
Panel
titleQuery
Column1
Code Block
languagetext
themeDJango
REMAP_VALUES("Table1".ACTIVITY, ['B', 'BC'], ['C', 'BC'])
Section
Column
width50%
Panel
titleInput
Table1
CASE_ID : INTACTIVITY : STRINGTIMESTAMP : DATE
1
'A'
Sun Jan 01 2017 13:00:00.000
1
'B'
Sun Jan 01 2017 13:01:00.000
1
'C'
Sun Jan 01 2017 13:02:00.000
Column
width50%
Panel
titleOutput
Result
Column1 : STRING
'A'
'BC'
'BC'


Hiding

Example


Panel
borderColorgrey
Section
REMAP_VALUES hides activity B by mapping it to null.

Section
Panel
titleQuery
Column1
Code Block
languagetext
themeDJango
REMAP_VALUES("Table1".ACTIVITY, ['B', NULL])
Section
Column
width50%
Panel
titleInput
Table1
CASE_ID : INTACTIVITY : STRINGTIMESTAMP : DATE
1
'A'
Sun Jan 01 2017 13:00:00.000
1
'B'
Sun Jan 01 2017 13:01:00.000
1
'C'
Sun Jan 01 2017 13:02:00.000
Column
width50%
Panel
titleOutput
Result
Column1 : STRING
'A'
null
'C'