Reporting in HCO

I have deployed HCO in our environment

Unfortunately the OOTB reporting for our ISP  availability is based on a daily

We want to be able to generate cumulative weekly and monthly reports for different ISPs.

It appears this has to be done via SQL 

Please can someone assist me here