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_OCCURRENCE['QUEUED']
TO
FIRST_OCCURRENCE['RESOLVED'] OR FIRST_OCCURRENCE['RESTORED']
,
REMAP_TIMESTAMPS("eventlog"."TIMESTAMP", HOURS))
)
The part without OR FIRST_OCCURRENCE['RESTORED'] works fine