Skip to Content

How do I show how long it has taken for there to be a field change?

Apr 22 at 06:16 AM


avatar image
Former Member

In my group we have 4 different codes that show what the status is of the part. For this case, I will call them: A,B,C, and D. Each code has a certain meaning behind it ex. A= Conforming to spec, B= Our fault, C= Customer damage etc. For my metrics, I would like to know when the data makes a change. In other words, is there a downloadable field that I can use to extract the difference from when someone changes the part code from A to B.

The resulting report should say: The part was A for 31 days, then it was B for 23 days and closed as D after a total of 54 days. (Those numbers were just examples)

If anyone has any idea how I could go about this, it would be greatly appreciated. Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Yogini Thorat Apr 23 at 11:07 AM

Hello Tanner,

where do you maintain these codes for status?

10 |10000 characters needed characters left characters exceeded