Applies to:  CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 

Description

CALC_REWORK counts the number of activities per case. Which activities CALC_REWORK should take into account can be restricted by a filter.

Syntax

CALC_REWORK ( [ FILTER ] )

Examples

Example for CALC_REWORK on 3 cases without filter.
Query
Column1
CALC_REWORK()
Input
Table1
CASE_ID : STRINGACTIVITY : STRINGTIMESTAMP : DATE
'1''A'
Sun Jan 01 2017 13:00:00.000
'2''B'
Sun Jan 01 2017 13:01:00.000
'2''B'
Sun Jan 01 2017 13:02:00.000
'3''C'
Sun Jan 01 2017 13:03:00.000
'3''D'
Sun Jan 01 2017 13:04:00.000
'3''E'
Sun Jan 01 2017 13:05:00.000
Output
Result
Column1 : INT
1
2
3



Example for CALC_REWORK with filter on activity C and E.
Query
Column1
CALC_REWORK(Table1.ACTIVITY = 'C' OR Table1.ACTIVITY = 'E')
Input
Table1
CASE_ID : STRINGACTIVITY : STRINGTIMESTAMP : DATE
'1''A'
Sun Jan 01 2017 13:00:00.000
'2''B'
Sun Jan 01 2017 13:01:00.000
'2''B'
Sun Jan 01 2017 13:02:00.000
'3''C'
Sun Jan 01 2017 13:03:00.000
'3''D'
Sun Jan 01 2017 13:04:00.000
'3''E'
Sun Jan 01 2017 13:05:00.000
Output
Result
Column1 : INT
0
0
2



  • No labels