I have a requirement to get the failure duration on all the systems which are present in the below table which are mapped to unique key
SystemID .So far I have created a master calendar based on start _time column as that is the time the 1st system was added . Now I have a requirement . have to calculate the overall failure % of the each system .
So below are my requirement
1. If no Date is selected in the master calendar so I should be able to get the overall failure % of all the system starting from minimum value of start_time to till current time . this I need to show as overall in text box as well as for each system id in straight table
2. If only Year is selected in the master calendar so I should be able to get the overall failure % of all the system starting from minimum value of start_time to till current time for selected year . this I need to show as overall in text box as well as for each system id in straight table
3. If month is selected in the master calendar so I should be able to get the overall failure % of all the system starting from 1st date of month to till last date of selected month and this should display the failure % of the failure happened in the selected month as overall in text box as well as for each system id in straight table .
4 . if a date is selected , then the failure % should be calculated based on failure duration for that particular day
Here for all the cases I need to consider "Unplanned" FailureName only for all the calculation.
