C
Candyman
I hope i can explain this. This may be a challenge, or maybe not. I am
charged with creating trending charts for test failures. In a particular
report we may have 6 tests with 4 different failure reasons. To be tracked
over time against multiple lines of business. (multiple reports, multiple
tests, multiple failure reasons) I hope I am on the right track with this
process.
I need to eventually come up with a data entry of
Report_Name, ReportDate, Business, Test, FailRsnCount1, FailRsnCount2,
FailRsnCount3, FailRsnCount4
I have a table with the report name and tests and failure reasons.
Report_Name, Test, Test_NM_1, Test_Nm_2, Test_Nm_3, Test_Nm_4
I can get values for Test “Date of Birth†Error Reason: ‘Missing DOB’ Count:
2.
How can I retrieve the name of the failure reasons from the log table based
on the FailReasonCnt Column to create the titles for the trend report?
I feel to completely normalize the table would be insane. Is there a way to
pick the value of the failure reason and ‘column’ – use the column # to store
the error count in the proper field column. Then conversely, based on the
column # for that test retrieve the reason name for the count and charting
label?
Trending would show that over time the reason for this error changed form
‘Missing DOB’ to ‘Invalid DOB’ ?
I hope this makes sense. Please help!
Candyman
charged with creating trending charts for test failures. In a particular
report we may have 6 tests with 4 different failure reasons. To be tracked
over time against multiple lines of business. (multiple reports, multiple
tests, multiple failure reasons) I hope I am on the right track with this
process.
I need to eventually come up with a data entry of
Report_Name, ReportDate, Business, Test, FailRsnCount1, FailRsnCount2,
FailRsnCount3, FailRsnCount4
I have a table with the report name and tests and failure reasons.
Report_Name, Test, Test_NM_1, Test_Nm_2, Test_Nm_3, Test_Nm_4
I can get values for Test “Date of Birth†Error Reason: ‘Missing DOB’ Count:
2.
How can I retrieve the name of the failure reasons from the log table based
on the FailReasonCnt Column to create the titles for the trend report?
I feel to completely normalize the table would be insane. Is there a way to
pick the value of the failure reason and ‘column’ – use the column # to store
the error count in the proper field column. Then conversely, based on the
column # for that test retrieve the reason name for the count and charting
label?
Trending would show that over time the reason for this error changed form
‘Missing DOB’ to ‘Invalid DOB’ ?
I hope this makes sense. Please help!
Candyman