Skip to main content
Solved

Can I calculate the duration of time spent on a each activity?

  • November 8, 2023
  • 1 reply
  • 54 views

Forum|alt.badge.img+4

Hi all,

 

I'd like to calculate ​average duration of the time on a each activity. Does anybody know how to do that?

 

I assume this calculation logic below works but its not so smart.

Assumption: we have activity A, B, C, and D.

 

(sum of time spent A to B, A to C, A to D) divided by (Count of A to B, A to C, A to D)...

 

My question is,

  1. Does celonis has such as functionality?
  2. Can we count the number of case ? (Bold part)

 

Thanks

 

 

Best answer by valmira.abdiu

hi @jumbo.szk ,

 

Kindly check the following article https://docs.celonis.com/en/calculations-on-activity-sequences.html

 

I hope it helps to answer your question.

 

Best,

Valmira Abdiu

1 reply

  • Celonaut
  • 67 replies
  • Answer
  • November 18, 2023

hi @jumbo.szk ,

 

Kindly check the following article https://docs.celonis.com/en/calculations-on-activity-sequences.html

 

I hope it helps to answer your question.

 

Best,

Valmira Abdiu