David_Hampson_90e289

updated

16 years ago

D

David_Hampson_90e289

2 Intern

243 Posts

0

2469

January 7th, 2011 03:00

Make an average of a field

This is another one driving me nuts!   I want to create a report showing the average size of full tapes for each backup server; however there does not appear to be a way of getting the report to produce an average for each backup server.  I start with the Media Details source and apply the Average operator but this results in a table which has server, volume name, size of volume (an average appears to be taken for all times that the volume details are recorded).  I have tried dropping the volume name and applying the Average function but no good.  Is there any way I can do this without having to import the results into Excel and produce the results there (very easily too).