Data Consolidation 1

[Jonchill]

I currently have a report that displays the throughput of traffic on a given network device, the data is captured in 14 min segments but I want to display just the hourly totals of data throughput.

See below the forumla I an currently using to display the data.

{Nodes.Site} = "Lincoln" and
{Nodes.Type_of_Device} = "PACS" and
{Nodes.Caption} like ["*RWDCWS*", "*RWDDWS*"] and
date({InterfaceTraffic.DateTime}) in Date (2007, 04, 01) to Date (2007, 04, 22) and
dayofweek({InterfaceTraffic.DateTime}) in 2 to 6 and
time({InterfaceTraffic.DateTime}) in time(8,0,0) to time(18,0,0)

The result from the above is

10/04/2007 12:00 Total Megabytes Transferred In Total Megabytes Transferred Out

10/04/2007 12:13:57 0 0

10/04/2007 12:27:59 0 0
10/04/2007 12:42:00 23 0
10/04/2007 12:56:01 28 0

Total Megebytes Transferred over the hour 51 0

I can't work out hw to only display the total after each hour and not each 15 min increment.

Any help would be much appreciated.

Thanks

Jon

 

[synapsevampire]

I must be overlooking something here, but if you group by the date and select for each hour won't that work using conventional summaries?

-k

 

[Jonchill]

As far as I'm aware I've grouped by time and summarised by the hour but it still shows the data between the hours. It might be something obvious I'm missing as I'm fairly new to Crystal.

Thanks

Jon

 

[synapsevampire]

Right click the datetime field, select change and set it to for each hour.

Now do your summaries at the group level, then suppress the details section.

-k

 

[Jonchill]

Thanks K, that worked a treat.

Jon