Here’s an example of a custom report you could create using the Nova Report Center.
You can create an Office 365 Users by Location report. The report shows your organization’s Office 365 users, broken down by location and department. This report could be helpful for planning helpdesk resources/staffing/coverage. The report includes a pie chart with the Office 365 Users data source. The report’s second section is a stacked bar graph with the Office 365 Users data source. Finally, the report contains a table which shows users’ display names, country/region and departments. 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 Office 365 Users by Location.
  3. You’ll add 3 sections to this report using the steps below:

Section 1: Users by Location Stats

  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 Users by Location Stats.
  4. Choose the Office 365 Users data source under the User Data data source category.
  5. Choose and organization and group, if applicable.
  6. Select the Pie chart type.
  7. In the Operator field select count.
  8. In the Applied to field select Display Name.
  9. In the Series name field select Country/Region.
  10. Click Close section.

Section 2: Users by Location and Department

  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 Users by Location Stats.
  4. Choose the Office 365 Users data source.
  5. Choose and organization and group, if applicable.
  6. Select the Stacked Bar chart type.
  7. In the Operator field select count.
  8. In the Applied to field select Country/Region.
  9. In the Series name field select Country/Region.
  10. In the Category field select Department.
  11. Click Close section.

Section 3: List of Users by Department

  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 Users by Department.
  4. Choose the Office 365 Users data source.
  5. Choose and organization and group, if applicable.
  6. Click the Select fields… link under Choose table fields
  7. Select Display Name, Country/Region and Department, and close the dialog.
  8. If desired, drag and drop the column names to re-order them.
  9. Set your desired amount of data within your table by changing the number in the ‘Limit’ text field.
  10. Click Close section.

After you’re done adding sections, click Save.
And here’s a video going through these steps:

Want more custom reports? Check out our examples here.

Print Friendly, PDF & Email