Skip to main content

Hello everyone!

I have the code below:

AVG(

   CALC_THROUGHPUT(

    ALL_OCCURRENCE_'Process Start'] TO FIRST_OCCURRENCE_'Incident assigned to a new operator'], 

    REMAP_TIMESTAMPS("activity"."SYS_CREATED_ON", SECONDS)

   ) / 60 /60

  )

which calculates averate throughput time until activity "Incident assigned to a new operator" occurs. I have however changed the data transformation script, so that this activity can now either be

  • "Incident assigned to an operator by service desk" OR
  • "Incident claimed by operator from incident pool"

Obviously this change broke my KPI, as what used to be one activity can now be either one of the two. I was hoping it would be possible to pass two strings to FIRST_OCCURRENCEn] (such as FIRST_OCCURRENCEu'Activity A','Activity B']), indicating I want to measure time until occurence of either "activity A" or "activity B", similarly to NODE_ALL,] vs NODEy], but unfortunately this is not possible. Does anyone have any idea how to solve this?

Many thanks!

Jan

What I'd try:

Use a CASE WHEN with PROCESS EQUALS. In the first WHEN select when the case has the first activity but not the second, and the opposite in the next when. Then add the calc_througput accordingly

 

HTH


Hi Jan,

 

Maybe the following would work for you:

 

AVG(

  CALC_THROUGHPUT(

   ALL_OCCURRENCEU'Process Start'] TO FIRST_OCCURRENCEU'Incident assigned or claimed'],

   REMAP_TIMESTAMPS(activity"."SYS_CREATED_ON, SECONDS),

   CASE WHEN "activity_table.column" = 'Incident assigned to an operator by service desk' OR "activity_table.column" = 'Incident claimed by operator from incident pool' THEN 'Incident assigned or claimed' ELSE "activity_table.column" END

 ) / 60 /60

 )

 

Best,

Bart


Reply