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.