Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23, 2018 at 11:07 AM

    Hello Tanner,

    where do you maintain these codes for status?

    Add comment
    10|10000 characters needed characters exceeded