Here’s an example of a custom report you could create using the Nova Report Center.
You create a OneDrive Usage report. The report shows which of your users are using OneDrive for Business most (the most items and the largest items). The report includes a vertical line bar graph with OneDrive User Data as the data source, sorted by item count (listed by user ID).  The report includes a table that also uses OneDrive User Data as the data source. This table is sorted by item size. Finally, the report has another a vertical line bar graph with OneDrive User Data as the data source. This table is filtered by item size (results in this graph also listed by user ID). Here’s how the finished report looks:

Here are the steps to create this report:

  1. Click Create Report.
  2. Enter a report title, for example OneDrive Usage.
  3. You’ll add 3 sections to this report using the steps below:

Section 1: Top 10 Users by Item Count

  1. Click the plus sign to add a section to the report.
  2. Click the Chart or Pivot section type to begin editing the section.
  3. Add a section title, for example Top 10 Users by Item Count.
  4. Choose the OneDrive User Statistics data source.
  5. Choose an organization and group, if applicable.
  6. Select the Vertical Bar chart type.
  7. Under the Operator section, select ‘Sum‘.
  8. Under the ‘Choose applied to’ section, click ‘Select field…’, and click on the ‘Item Count’ checkbox.
  9. Under the ‘Series name’ section, click ‘Select field…‘, and click the ‘User ID’ checkbox.
  10. Click the Add sorting link.
  11. Click the ‘Select field…’ link, and click the ‘Item Count’ button.
  12. Sort in descending order.
  13. Under the ‘Offset‘ text field, put 0.
  14. Under the ‘Limit‘ text field, put 10.
  15. Un-check the ‘Overflow‘ button.
  16. Click Close section.

Section 2: Top OneDrive Users

  1. Click the plus sign to add a section to the report.
  2. Click the Table section type to begin editing the section.
  3. Add a section title, for example Top OneDrive Users.
  4. Choose the OneDrive User Staistics data source.
  5. Choose and organization and group, if applicable.
  6. Click ‘Select field…‘, and select User ID, Item Size, Item Count, and Last Activity Date in this order, and then close the dialog.
  7. If desired, drag and drop the columns, to re-order them.
  8. Click the Add sorting link.
  9. Click the ‘Select field...’ link, and then select Item Size.
  10. If required, you can limit the amount of users in this table. Under the ‘Limit‘ text field, choose how many users you want in this table by changing the number.
  11. Click Close section.

Section 3: Top 10 Users by Item Size

  1. Click the plus sign to add a section to the report.
  2. Click the Chart or Pivot section type to begin editing the section.
  3. Add a section title, for example Top 10 Users by Item Count.
  4. Choose the OneDrive User Statistics data source.
  5. Choose an organization and group, if applicable.
  6. Select the Vertical Bar chart type.
  7. Under the Operator section, select ‘Sum‘.
  8. Under the ‘Choose applied to‘ section, click ‘Select field…‘, and click on the ‘Item Size‘ checkbox.
  9. Under the ‘Series name‘ section, click ‘Select field…‘, and click the ‘User ID‘ checkbox.
  10. Click the Add sorting link.
  11. Click the ‘Select field…‘ link, and click the ‘Item Size’ button.
  12. Sort in descending order.
  13. Under the ‘Offset‘ text field, put 0.
  14. Under the ‘Limit‘ text field, put 10.
  15. Un-check the ‘Overflow‘ button
  16. Click Close section.

After you’re done adding sections, click Save.

Want more custom reports? Check out our examples below:

Print Friendly, PDF & Email