I have created a "Call Logging database" in which IT calls are logged. I could able to calculate the time taken to resolve a call. It appears in a view as a column value for each call.
Now I want to calculate the total % monthly uptime of a particular device by totaling the time taken in resolving the each call of that category in minutes and then subtracting it from total minutes in that month, dividing it by 100.
Pls help me in doing the same.
Thanks & Regards