I have table like this. So here in below table i have
5 Keys with outage type 0 and out of those for only KEYS(192408 ,192412,192410) i have got some duration in seconds
So here duration_seconds is the amount of time the system is down and hence i need to get the %of uptime by dividing the duration_Seconds with total duration and then substract that value by 1 to get the uptime %.
|232320||192408||3/19/2015 17:29||3/19/2015 17:29||0||0|
|232321||192409||3/19/2015 17:29||3/19/2015 17:29||0||0|
|232322||192410||3/19/2015 17:29||3/19/2015 17:29||0||0|
|318194||192412||5/15/2015 16:22||5/15/2015 16:22||0||0|
|318195||192408||5/20/2015 23:48||5/21/2015 0:12||1414||1|
|318196||192410||5/25/2015 22:30||5/25/2015 23:30||1200||1|
|318196||192412||5/5/2015 22:30||5/6/2015 8:10||34800||1|
Here suppose i need to pull out the average uptime% of the month of may by selecting the Month May from Master Calendar so in above example i have only one KEY 192410,192412 as outage type 1 in the table so for the month of MAY all the other 3 KEYS values should be considered as 100% and then the average of all the percentages should be calculated and shown in TEXT BOX .