Forum Discussion
Defect age
That sample data appears to leave a lot of things out. For one thing, although there are different codes under the heading "Defect" it's not at all clear whether we're referring in each instance to the same product, or even the same serial number of the same product. So for starters, you'd need to be more specific as to "Defect of which instance of which product".... at least two more columns.
And since the dates in your sample don't relate to the dates in your textual description, that compounds the confusion.
Do you have an actual workbook started? Is it possible for you to provide an actual copy of that actual workbook? You can post it on OneDrive or GoogleDrive with a link pasted here that grants access.
Please see if attached document provides enough detail. Basically, when defect is submitted, it's New, then once defect status changes (column G) to Implementation Review, how many days did it take, and when status changes again, how many days did it take.......Hope that makes sense. thanksmathetes
What's the relationship between "MVP" and "Defect"? I don't see a pattern that I can make sense of, not that I've spent hours trying to figure them out.
How do you propose to deal with something like the first row in that sample? And any others where "date last updated" is present? Does it supersede "Created on Date"? Why don't you create a whole new row for an update? From a design point of view, it doesn't make a lot of sense to create a single row with two transactions in it.
Could you create a newer sample showing the results you expect for a representative few of the rows, explaining those results?
mathetes Hi, The MVP column represents the "phase" of the project and really has no relevance to this example. I inadvertently included it so I removed. I've been tracking the Created on Date which represents the date defect was opened. The Date Last updated reflects the date any comments, status, etc. changes. This allows me to filter on the most recent updates (deltas) without having to scroll through the hundreds of defects. There are multiple people updating this tracker so sometimes "Date last updated" is missing. As a result, are there additional details i should be capturing to make tracking the age simpler? Ultimately trying to create a mechanism to determine from the time the defect is opened--how long it takes Implementation Team to review the defect? How long does it take development to solution? How long is it taking the client to retest?, etc. I've provided a newer sample with expected results so hope this is clearer. Thanks for all of your help!
