Hi, how can I achieve a calculation with an OR / INLIST('RESOLVED','RESTORED')
This formula is not working. Do I need to construct a case when first?
Â
AVG(
Â
 CALC_THROUGHPUT(
  FIRST_OCCURRENCER'QUEUED']
  TO
  FIRST_OCCURRENCEC'RESOLVED']  OR  FIRST_OCCURRENCE_'RESTORED']
  ,
Â
 REMAP_TIMESTAMPS("eventlog"."TIMESTAMP", HOURS))
 )
Â
The part without OR Â FIRST_OCCURRENCEÂ'RESTORED'] works fine
Hi Vincent,
Â
You can use the REMAP_VALUES as the last argument of the CALC_THROUGHPUT for that:
e.g.:
 CALC_THROUGHPUT ( FIRST_OCCURRENCE C 'QUEUED' ] TO LAST_OCCURRENCE N 'R' ] , REMAP_TIMESTAMPS ("eventlog"."TIMESTAMP", HOURS), REMAP_VALUES ( "eventlog"."ACTIVITY_NAME" , t RESOLVED' , 'R' ] , RESTORED' , 'R' ] ) )
Â
Regards,
Roland
Â
Wow, great!, works like a charm
Hi Vincent,
Â
You can use the REMAP_VALUES as the last argument of the CALC_THROUGHPUT for that:
e.g.:
 CALC_THROUGHPUT ( FIRST_OCCURRENCE C 'QUEUED' ] TO LAST_OCCURRENCE N 'R' ] , REMAP_TIMESTAMPS ("eventlog"."TIMESTAMP", HOURS), REMAP_VALUES ( "eventlog"."ACTIVITY_NAME" , t RESOLVED' , 'R' ] , RESTORED' , 'R' ] ) )
Â
Regards,
Roland
Â
I didn't know this! Thanks for sharing Roland
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
