Hi Marvin,

you could do with the following:

• use document creation date per month as dimension: ROUND_MONTH (doc_creation_date)
• use one of the following as KPI with Decimal Number as formatting.

 

Happy path:

MEDIAN(CASE 

  WHEN MATCH_PROCESS_REGEX ( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", ' Activity_A ' >> ' Activity_B ' ) = 1 

  THEN CALC_THROUGHPUT (FIRST_OCCURRENCEU' Activity_A '] TO FIRST_OCCURRENCEU' Activity_B '], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES"."EVENTTIME", HOURS ) )

  ELSE NULL END)

 

Non Happy Path:

MEDIAN(CASE 

  WHEN MATCH_PROCESS_REGEX ( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", ' Activity_A ' >> . >> ' Activity_B ' ) = 1 

  THEN CALC_THROUGHPUT (FIRST_OCCURRENCEF' Activity_A '] TO FIRST_OCCURRENCEF' Activity_B '], REMAP_TIMESTAMPS("_CEL_P2P_ACTIVITIES"."EVENTTIME", HOURS ) )

  ELSE NULL END)

 

and if you put both KPIs in the same graph, you can even compare the figures.

regards

Marc

 

---

Marc Rillaerts! Thank you very much!

 

You really helped me out and I learned a lot about how to use >> and >>.>> in PQL. This was the missing link!

 

I highly appreciate your input.

 

The numbers don't exactly match with the Throughput Time (Details) tab. Is there any reason for this? It's around 10-20% difference.

A second question would be why the Median calculation only returns whole numbers without decimals, although I selected Decimal format with ,.2f.

 

Thanks a lot for you help again!

 

Best regards

Marvin

---

Marc Rillaerts! Thank you very much!

 

You really helped me out and I learned a lot about how to use >> and >>.>> in PQL. This was the missing link!

 

I highly appreciate your input.

 

The numbers don't exactly match with the Throughput Time (Details) tab. Is there any reason for this? It's around 10-20% difference.

A second question would be why the Median calculation only returns whole numbers without decimals, although I selected Decimal format with ,.2f.

 

Thanks a lot for you help again!

 

Best regards

Marvin

Hi Marvin,

the pleasure is all mine to have helped you out .

For the difference in figures, calc_throughput or a time difference statement ‘just’ calulates the time spent between the 2 given activities. This will then include both your happy and unhappy flow.

The formula I used is first checking which flow to use to calculate the median time. And it uses ‘null’ for the cases that are not relevant.

For the rounded result, I have no clue as such. It’s difficult without seeing the screen. Sorry for that.

regards

Marc

Marc Rillaerts
from my mobile.

---