Customize DPA report

Question

Hello All,

Recently, I would like to customize report DPA. I successed to do that :

Sauvegarde Avamar/Agents - Heure sauvegarde

	Object	VMs / SITE	Succeeded	Failed	Total Size (GB)	Success Rate (%)
	site1	70	64	6	18,0	91,4
	site2	153	93	60	26,0	60,8
	site3	50	30	20	12,0	60,0
	site4	1	0	1	0,0	0,0
	site5	119	73	46	29,0	61,3
	site6	9	9	0	2,0	100,0
	site7	235	225	10	42,0	95,7
	site8	201	129	72	49,0	64,2
	site9	64	45	19	49,0	70,3
	site10	2	2	0	1,0	100,0
	site11	8	8	0	5,0	100,0
	site12	1	1	0	0,0	100,0
	site13	186	171	15	27,0	91,9
	site14	2	2	0	0,0	100,0
	site15	8	8	0	1,0	100,0
	site16	1	1	0	23,0	100,0

Total		1110	861	249	284,0

I could add a last line to have a SUM of VMS/SITES, Success number, Total Size. But I would like to have also the %Sucess Rate of the Total

i.e to do this operation : (Succeeded/VMS Sites)*100

i.e (861/1110)*100

%Success Rate = 77.568%

Anybody can help me please ?

DavidRussell1 · Answer

Hi Sariaka,

When you add the summary row to the report you should be able to select the Success Rate column and change the operation so that it is Average as opposed to Sum.

Thanks

David

David Russell

EMC

sariaka · Answer

Hi David,

Thanks for your answer,

Indeed I saw Average operation but, When I selected it, the result is the average of the column Success Rate (%)
I don't have the same result than when I did operation myself.

i.e with average operation = (91.4+60.8+60+0+61.3+100+95.7+64.2+70.3+100+100+100+91.9+100+100+100) / 16=74.6625%

I would like to have the Success Rate (%) of the row added.

i.e (861/1110)*100 = 77.568%

May be, can we add a new operation to do that ? or a variable ?

Thanks,

Sariaka

DavidRussell1 · Answer

Hi Sariaka,

Unfortunately I am not aware of any way to do that within the report. The average function will take the values in the Success Rate column and divide by the number of values, which is obviously different to how you want it calculated. The only way I can think to achieve this would be to have a separate report which displayed the totals.

Thanks

David

David Russell

EMC

Data Protection Advisor

Customize DPA report

Was this post helpful?