Summarize customer-wise uptime percentage

[cvudhayan]

Dear All,
New to message board.
I have couple of customers and each customers have number of services.
Each services and customers need to be calculated for uptime percentage.

Can anyone help me in this

[TABLE="width: 310"]
<tbody>[TR]
[TD]

custname​

[/TD]
[TD]

linkname​

[/TD]
[TD]

opendt​

[/TD]
[TD]

resdt​

[/TD]
[/TR]
[TR]
[TD]

A​

[/TD]
[TD]

LL1​

[/TD]
[TD]

7/27/12 2:37​

[/TD]
[TD]

7/27/12 4:30​

[/TD]
[/TR]
[TR]
[TD]

A​

[/TD]
[TD]

LL1​

[/TD]
[TD]

8/2/12 6:06​

[/TD]
[TD]

8/2/12 11:57​

[/TD]
[/TR]
[TR]
[TD]

A​

[/TD]
[TD]

LL1​

[/TD]
[TD]

7/28/12 15:15​

[/TD]
[TD]

7/28/12 15:16​

[/TD]
[/TR]
[TR]
[TD]

B​

[/TD]
[TD]

BC1​

[/TD]
[TD]

8/6/12 9:53​

[/TD]
[TD]

8/6/12 9:54​

[/TD]
[/TR]
[TR]
[TD]

B​

[/TD]
[TD]

BC1​

[/TD]
[TD]

8/3/12 9:49​

[/TD]
[TD]

8/3/12 19:26​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD1​

[/TD]
[TD]

7/30/12 7:29​

[/TD]
[TD]

7/30/12 8:52​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD1​

[/TD]
[TD]

7/31/12 9:44​

[/TD]
[TD]

7/31/12 10:55​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD2​

[/TD]
[TD]

8/1/12 12:18​

[/TD]
[TD]

8/1/12 12:27​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD3​

[/TD]
[TD]

7/30/12 6:57​

[/TD]
[TD]

7/31/12 18:09​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD3​

[/TD]
[TD]

7/30/12 7:23​

[/TD]
[TD]

7/30/12 7:24​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD3​

[/TD]
[TD]

7/30/12 7:23​

[/TD]
[TD]

7/30/12 7:24​

[/TD]
[/TR]
[TR]
[TD]

C​

[/TD]
[TD]

CD4​

[/TD]
[TD]

8/1/12 12:18​

[/TD]
[TD]

8/1/12 12:27​

[/TD]
[/TR]
[TR]
[TD]

D​

[/TD]
[TD]

AA1​

[/TD]
[TD]

7/27/12 13:56​

[/TD]
[TD]

7/27/12 14:26​

[/TD]
[/TR]
[TR]
[TD]

D​

[/TD]
[TD]

A1​

[/TD]
[TD]

8/2/12 10:15​

[/TD]
[TD]

8/2/12 10:16​

[/TD]
[/TR]
</tbody>[/TABLE]

​

 

[Laurent C]

I guess opendt and resdt represent the start and end time of a server down-time.

What are the starting points of your calculation for the services?

 

[cvudhayan]

I guess opendt and resdt represent the start and end time of a server down-time.

What are the starting points of your calculation for the services?

you are right

 

[Laurent C]

You can define a new calculated column
lengthdt := [resdt]-[startdt]
to get the total down-time, expressed in days.

The percentage of down-time will be best represented by a measure like
1-[lengthdt]/[total time the service should have been up and running]

Now the question is, when was each service launched? Without the information you cannot calculate the [total time the service should have been up and running] part.