For simplicity, I have reduced the dataset down to a single device. So, for the week of 1/1/2017, the weekly MTBF rate is:
2 devices * 7 days in a week --------------------------- = 7.0 2 crashes
When I load this data in a table, I am only able to compute the MTBF value for the weeks starting with the first checkin date (1/1/2017) going forward. However, I would like to count all of those weeks between 11/1/2016 (StartupDate) and 1/1/2017 (first CheckinDate) as having no failures.
2 devices * 7 days in a week --------------------------- = 14.0 1 (zero crashes)
Do you have any suggestions on how to solve this problem? The only way I can think of is to insert rows of data with a zero failure count for all of those weeks between 11/1/2016 and 1/1/2017 for each device?
For example, the resulting table would look like this (newly inserted rows are shown in italics😞
How could this be accomplished within the load script? or if you have another suggestion to solve the problem in a different way, let me know your thoughts! Thank you, Jeff
