Using the Pivot Grid

Visually analyze data according to combinations of variables in the Pivot Grid.

1. Click Load from Database in the Dashboard.

2. Double-click the desired file system scan.

3. Click Pivot Grid.

   

4. Select Size and Count (residing in the Measures folder) from the Pivot Fields region and drag them to the area marked Drop Data Items.

5. Again in the Pivot Fields region, select File Extension and drag it to the area marked Drop Row Fields Here.

6. Observe the totals now calculated for the data variables.

   

7. Expand Access Time to locate Modify Time (Month) in the Pivot Fields region and drag it to the area marked Drop Column Fields Here.

   

8. Click the filter icon from the Access Time (Month) filter that you just placed.

   

9. Deselect all but one month and click OK.

10. Click the Chart tab.

11. Highlight three consecutive rows to view the data analyzed as graphs in the Chart region.

    

12. Experiment with different chart views of the data using the Chart Presets options.

13. Double-click a selected cell from the table to access the Scan Data Details table, which specifies all files accessed by that user during that month.

14. Right-click a file From the Scan Data Details table, and select Open Folder to open the parent folder and examine the file, move it to another location, or delete it.

15. Click the Reports tab.

16. Highlight three consecutive rows.

17. Click Generate Report.

18. You can print the report or export it to several different formats.