Hi,
I have test measurement data from a product and I would like to present in a line chart with the average amount of failed products perd day. For example a pass product should have Measurement 1 > 0.01
In dayly log files( with arround 72000 units tested per day) I have the information in the following way (1-pass/ 0-fail)
Date Time Product id Measurement 1 Pass/fail
26/03/2019 00:17:04 6EEC9 0.0108 1
Since I have dayly files with the test information of a whole month, I would like to present the dayly average or percentage of failed units. I dont know how to arrange or model my data to be able of present a line chart plot (x-axis-date in days 1-30 and y-axis average or % of failed units)
I understand tha in some way I should modify the data measurement in tables so I can estimate the failed % per day.
1.But I wonder if someone can help me to suggest how to moddel my data??
2.Should I create an additonal table with the pass % result of each day ?? I wonder if there is an easier way since I require to update the information with new data of everyday.
thank you in advance
