Wireless Access Point Peak Client Connections Report Per Day

Hi Thwackers

I need some help once again with reporting, I want to generate hat supplies me with the peak wireless clients connections per site per day. We have about +/- 50 remote sites and have numerous access points deployed at each branch site. Our Access points naming convention is structured to represent the branch they are located.

I have pulled the standard build in report Average and Peak Number of Clients by Access Point Last 7 Days which is very helpful but to filter all our branches per day and then provide the sum count is a bit of tedious task, custom reporting skills is not good at all. Below is what the build in report provides and also a good explanation on what I require

In a nutshell I want the report to group all the access points in SITE A and then provide the sum values of the Average and Peak by group.