Skip to main content
Question

Number of Hours spent on Rework

  • October 28, 2020
  • 6 replies
  • 10 views
.
Level 1
Hello Community! I am new to Celonis, and I have been trying in the last month to develop a job where I need to identify and quantify the Reworked Activities in a Process. I was able to calculate the time spent each time the Activity is executed within a given Case, but I was unable to filter only the Reworked Activities. I only need to show the Number of Hours spent on Rework Activities. What Ive managed to build so far is this: Reworked activities highlighted in yellow image929530 137 KB image1157593 42 KB Dimension TARGET("Activities.Activity) KPI TARGET ( REMAP_TIMESTAMPS ( Activities.Timestamp, MINUTES ) ) - SOURCE ( REMAP_TIMESTAMPS ( Activities.Timestamp, MINUTES ) ) Thank you!

6 replies

C
Level 0
Hi Thiago, How do you identify the rework cases in your usecase? If you have the conditions with which you can identify rework cases, then you can use for example a CASE WHEN statement to filter them. You can also filter cases directly in the Process Explorer be clicking on an activity or a connection and selecting with or without and then Keep Selections. Best regards, Celonis Data Science Team
.
Level 1
  • .14600830
  • Author
  • Level 1
  • October 29, 2020
614/5000 Hi! In my case, in Happy Way, the activities are not repeated. I identified the Reworked Activities in another Analysis, counting the Activities that had repetitions, but I was unable to reproduce the same calculations in this new table. It is not feasible for me to do this through the Process Explorer, as I have many Cases and Variants in the Log. The calculations I made for the Rework count were: Dimension: Activities.Activity KPI: MAX(INDEX_ACTIVITY_TYPE (Activities.Activity)) Component Filter: FILTER (CASE WHEN ACTIVATION_COUNT (Activities.Activity) > 1 THEN 1.0 ELSE 0.0 END) = 1 Thank you!
C
Level 0
Hi Thiago, The calculation logic looks good and if it already worked on the other analysis it should be correct. Then the problem must be in the difference of the tables or of the data. Can you tell what the difference to the previous analysis is or if the data is somehow different? Best regards, Celonis Data Science Team
.
Level 1
  • .14600830
  • Author
  • Level 1
  • October 29, 2020
When I try to apply one of the calculations to the other table, an error occurs with the following message: > No common parent was found - check your scheme. The data is the same, I just created two different OLAP Tables to test the calculations. I dont know how to resolve this error.
C
Level 0
Hi Thiago, The message > No common parent was found - check your scheme. refers to the fact that the KPI can not be joined with the dimension, and thus not displayed in the table. Here you can find a more detailed description of the Error you are facing from the help page: image1506617 57.8 KB Best regards, Celonis Data Science Team
.
Level 1
  • .14600830
  • Author
  • Level 1
  • October 29, 2020
Well, I understood the restrictions related to the error, but I still dont know how to solve my problem How can I do this Rework Calculation by Activity?
Community Code of ConductAccessibility statement