95/5 Billing - Change to Report at Mbps Instead of bps

Hi...I would like to change the reporting on the 95/5 calculation to Mbps vs bps. Is there a way to do that? Reason is that we bill customer on a per Mb basis.

TIA,

Find more posts tagged with

955_95th_percentile

Accepted answers

All comments

FormerMember

Yes, it can be done, but you'll have to change the SQL query for the report..

tbone

This is great news - can you point provide where to find the data to make the change. We are running a registered version of SQL with SQL Studio.

josh.clark

I haven't tried this out, but this should work:

Open the Report in Report Orion Report Writer
Click on the SQL tab
About 10 lines down, you'll see lines for MaxBps_In95, MaxBps_Out95, and MaxBps_95.
Change these lines to look like this:

Maxbps_In95 / 1000000.0 as Maxbps_In95,
Maxbps_Out95 / 1000000.0 as Maxbps_Out95,
Maxbps_95 / 1000000.0 as Maxbps_95

Now click on the Field Formatting tab and change Format to "No Formating"
- If you don't do this, we'll keep trying to convert the value to a prettier format.

tbone

Thanks Josh that worked perfectly....only thing is the report is stil adding 'bps' after each data entry. Can you tell me where to go edit that out. I changed the Column Header, no prob but am not sure how to get rid of the 'bps'.