Dell PowerConnect W Clearpass 100 Software 3.9 Deployment Guide - Page 350

Creating Sample Reports Report Based on Modifying an Existing Report This sample involves modifying the predefined Number of users per day report to report on the number of users per week. 1. Select the "Number of users per day" report. 2. Click the Edit link. This opens the Report Editor. 3. Click Report Type in the Report Editor, as you need to change the title of the report to "Number of users per week". Because you want to report on weekly data, the date range should also be changed to a figure that is divisible by 7. To see the last 6 weeks of user numbers, enter 42 for the date range. 4. Click the Save Changes button to return to the Report Editor. 5. Click the Classification option in the Report Editor. The Bin classification needs to be changed from days to weeks. This is done by clicking on the Bin and then clicking the Edit button. 6. The Classification method should be changed to Time measurement: bin by weeks. The Bin Offset may be changed to suit your time zone, See "Binning Example - Time Measurements" in this chapter for more information. 7. Click the Save Changes button. 8. Click the Back to report editor link to return to the Report Editor. Click the Output Series option because you need to change the formula to calculate in weeks instead of days. This means changing the expression to multiply by 604800, as shown in the screen below. Click the Apply button to make your changes take effect. Click the Save Changes button at the bottom of the window to save the changes to the output series. Click the Back to report editor link to return to the Report Editor. Click Final Report to run the report and verify the changes you have made. 350 | Report Management ClearPass Guest 3.9 | Deployment Guide