Hopefully I can explain this clearly.
I have a database that tracks prototype testing. Each time an engineer performs any testing on a product they are to log the start and end times of their usage. The idea is to get an accurate utilization measurement of prototype usage. The company has a large list of the metrics that each product must meet the target of to go in to production. Every similar prototype has to be tested for each of these metrics.
We are currently in a beta test for the tool and are therefore going through a bunch of iterations, figuring out what works and what doesn't, adding requested features, etc. One of the requests is to create some sort of query that will list what metrics have been tested and what ones haven’t, filtered by product. I can think of doing this in two ways. First is to list all of the metrics, regardless of having been tested and for ones that don’t have a length, i.e. no log at all for that specific metric, a test length of zero or NA could be used. Second would be to just list all of the metrics that don’t have a log associated for a given product. This would give the planning engineer an idea of what hasn't been done or hasn't been logged and allow them to speak with testing engineers to ensure the completeness and integrity of the data.
I have attached a slimmed down version of the database with all the pertinent tables and queries included. I would very much appreciate some help with this issue and thank anyone who has the time to help.
I have a database that tracks prototype testing. Each time an engineer performs any testing on a product they are to log the start and end times of their usage. The idea is to get an accurate utilization measurement of prototype usage. The company has a large list of the metrics that each product must meet the target of to go in to production. Every similar prototype has to be tested for each of these metrics.
We are currently in a beta test for the tool and are therefore going through a bunch of iterations, figuring out what works and what doesn't, adding requested features, etc. One of the requests is to create some sort of query that will list what metrics have been tested and what ones haven’t, filtered by product. I can think of doing this in two ways. First is to list all of the metrics, regardless of having been tested and for ones that don’t have a length, i.e. no log at all for that specific metric, a test length of zero or NA could be used. Second would be to just list all of the metrics that don’t have a log associated for a given product. This would give the planning engineer an idea of what hasn't been done or hasn't been logged and allow them to speak with testing engineers to ensure the completeness and integrity of the data.
I have attached a slimmed down version of the database with all the pertinent tables and queries included. I would very much appreciate some help with this issue and thank anyone who has the time to help.
