Creating a custom chart or pivot section
Charts and pivots give you a great range of graphs to view a variety of data across your tenant. Charts and pivots also give you access to view the many data sources Nova has on offer in easy to analyze diagrams.
9.Select your chart type. This includes the following types:
10. Choose your operator (average, count, sum, min, max).
11.Choose your Applied to field. This represents your Y axis.
12. Choose your Series name. This is your X axis.
13. Optionally, choose your category. This is additional information with your X axis.
14. If applicable, add sorting and filters.
15. Add an offset and a limit.
a.An Offset is the starting record for the section.
b.The Limit is the number of records returned and visible within the report.
|
|
NOTE: When downloading a section, this limit is ignored. |
16. Choose whether you would like the Overflow option. Setting an overflow will gather objects outside of a specific range into its only section.
17. Optionally, choose whether to drill down data fields. These can be fields you have selected for your section, or other fields within the data source.
|
|
NOTE: You have the option to view the raw data in your chart. |
You can now save your chart, and close the section.
Custom chart example: Microsoft Entra ID users by location
You can create an Microsoft Entra ID Users by Location report. The report shows your organization's Microsoft Entra ID 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 Microsoft Entra ID Users data source. The report's second section is a stacked bar graph with the Microsoft Entra ID Users data source. Finally, the report contains a table which shows users' display names, country/region and departments. Here is how the finished report looks:
Here are the steps to create this report:
1.Click Create Report.
2.Enter a report title, for example Microsoft Entra ID Users by Location.
3.You will add 3 sections to this report using the steps below:
Section One: Users by Location Stats
|
1.Add a section title, for example Users by Location Stats, and a description if necessary. 2.Choose the Entra ID Users data source under the User Data data source category. 3.Select the Pie chart type. 4.In the Operator field select count. 5.In the Applied to field select Display Name. 6.In the Series name field select Country/Region. 7.Save and close the section. |
Section 2: Users by Location and Department
|
1.Add a section title, for example Users by Location Stats, and a description if necessary. 2.Choose the Entra ID Users data source. 3.Select the Stacked Column chart type. 4.In the Operator field select count. 5.In the Applied to field select Country/Region. 6.In the Series name field select Country/Region. 7.In the Category field select Department. 8.Click Close section. |
Section 3: List of Users by Department
|
Find this section in the tables section of this guide. |
After you are done adding sections, click Save.
Here is a video going through these steps.
Custom chart example: OneDrive usage
You can 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)
·vertical line bar graph with OneDrive User Data as the data source, sorted by item count (listed by user ID)
·a table that also uses OneDrive User Data as the data source. This table is sorted by item size.
·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 is how the finished report looks:
Here are the steps to create this report:
1.From the dashboard, click Create Report.
2.Enter a report title, for example OneDrive Usage.
3.You will add 3 sections to this report using the steps below:
Section One: Top 10 Users by Item Count
|
1.Add a section title, for example Top 10 Users by Item Count. 2.Choose the OneDrive User Statistics data source under OneDrive Data. 3.Choose an organization and group, if applicable. 4.Select the Column chart type. 5.Under the Operator section, select Sum. 6.Under the Applied to section, click Select field..., and select Item Count. 7.Under the Choose series name field, click Select field..., and select User Id. 8.Click Add sorting, then Select field..., and select Item Count. Sort in descending order. 9.Under the Offset text field, put 0. 10.Under the Limit text field, put 10. 11.Un-check the Overflow button. 12.Save and close the section. |
|
1.Add a section title, for example Top OneDrive Users. 2.Choose the OneDrive User Statistics data source. 3.Choose and organization and group, if applicable. 4.Click Select field..., and select User ID, Item Size, Item Count, and Last Activity Date in this order, and then close the dialog. 5.If desired, drag and drop the columns, to re-order them. 6.Click the Add sorting link, click Select field..., and then select Item Size. 7.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. 8.Save and close the section. |
Section 3: Top 10 Users by Item Size
|
1.Add a section title, for example Top 10 Users by Item Count. 2.Choose the OneDrive User Statistics data source under OneDrive Data. 3.Choose an organization and group, if applicable. 4.Select the Column chart type. 5.Under the Operator section, select Sum. 6.Under the Applied to section, click Select field..., and select Item Size. 7.Under the Series name section, click Select field..., and select User ID. 8.Click the Add sorting link, click Select field..., and select Item Size. 9.Sort in descending order. 10.Under the Offset text field, put 0. 11.Under the Limit text field, put 10. 12.Un-check the Overflow button 13.Save and close the section. |
After you are done adding sections, click Save.
Watch this video to see the above steps in action.
Custom chart example: License utilization
Here is another example of creating a report in the Nova Report Center.
Creating a report using License data sources allow you to get a scope of your license utilization within your tenant. This includes
·Assigned units licenses applied to users
·Unassigned units licenses not applied to users
·Idle units licenses applied to users but are not being used i.e. disabled/deleted users
See below to view the steps on how to create a chart section on your license usage.
|
Click Create Report. 1.Enter a report title, for example License Utilization. 2.Click the plus sign to add a section to the report, and a description if desired. 3.Add a title and description for your section. 4.Choose the Tenant License History data source under the License Data data source category. 5.Click column. 6.Under operator. choose Average. 7.Under Applied to, choose Percentage of Consumed Units. 8.Under Series name, choose License Name. 9.Set your offset and limits if necessary. 10.Save, then close the section. |
Custom chart example: Stacked inbound/outbound mail chart
Creating stacked graphs allows you to view multiple data fields in one easy to analyze chart. For example, in the chart below, we will create a stacked bar graph that shows the sum of inbound mail and outbound mail in one chart.
To begin creating your stacked chart:
|
1.Create a new section and give your chart a name. 2.Choose the Office 365 Mail Traffic data source under Exchange Data. 3.Choose Stacked Column. You can also select Stacked Bar or Stacked Line if you prefer. 4.For your operator, choose Sum. 5.For Applied to, choose Inbound Good Mail and Outbound Good Mail. 6.For Series Name, select Scan Date. 7.Add sorting, then select Scan Date. Choose descending from the drop down list. 8.Input your Offset and Limit. These are the amount of dates that appear in your chart. |
The data should now appear within your section. Click close section, then save. This chart can download as a PDF, if desired.
Creating a custom table section
Tables are the best method to view a wide variety of data within one report. Unlike the other report types in the Report Center, tables allow you to view multiple fields with data that you select to suit your needs.
9.Select your data fields for your table. You can add as many fields as you require.
10. Add aggregation, sorting and filtering to your table.
|
|
NOTE: Aggregation brings the amount of items you have in a field together. For example, if users are involved in multiple departments, aggregating on the Department field with the Count operator will show the number of departments for that user, rather than the name of the departments. |
11. Choose whether to enable paging. If paging is enabled, your table will be divided into multiple pages, depending on the amount of data collection for the section.
|
|
NOTE: Having paging enabled or disabled will not affect your download of your report; all data results will be listed within one table in your downloaded table. |
12. Choose your initial page size. This is the amount of records within each page.
You can now save your chart, and close the section.
Custom table example: Spam and malware report (30 days)
You can create an Office 365 Spam and Malware report section that shows the number of spam and malware attempts over the last 30 days. The report section includes a table showing all fields related to the Office 365 Mail Traffic data source. It is sorted in descending order by scan date, and the results are filtered so only the last 30 days display. Here is how the finished report section looks:
Click here to see how to create this report in your Nova Environment.
|
Here are the steps to create this report section: 1.Enter a section title, for example Office 365 Spam and Malware (30 days) and a description if necessary. 2.Choose the Office 365 Mail Traffic data source under the Exchange Data data source category. 3.Choose and organization and group, if applicable. 4.Click the Select field... link and select the following fields a.Scan Date b.Outbound Spam IP Block c.Outbound Spam Envelope Block d.Outbound Spam Content Filtered e.Outbound Malware f.Outbound Good Mail g.Inbound Spam IP Block h.Inbound Spam Envelope Block i.Inbound Spam Content Filtered j.Inbound Good Mail 5.Click Add sorting, then Select field, then select Scan Date, and make sure descending is selected. 6.Enter 31 in the Limit field. 7.Save and close the section. |
Here is a video of these steps.
Custom table example: License utilization
However, what if we would like a table that includes the raw data, as well as data that shows assigned, unassigned and idle units? Let us see how we do that here
|
1.Enter a section title, for example License Utilization Table, and a description if required. 2.Choose the Tenant Licenses data source under the License Data data source category. 3.Under choose table fields. select, in this order: a.License name b.Percentage of consumed units c.Assigned Units d.Unassigned Units e.Idle Units 4.Set your offset and limits if necessary. 5.Save, then close the section. |
Check out this video on how to create this report below.
Custom table example: Assigned licenses over time
You may want to see assigned licenses for a specific license within your environment over a certain period of time. The step by step process below explains how to do that.
|
|
NOTE: Our license example is PowerBI, but use which license is relevant to your environment as you go through the steps. |
See how to create this report.
|
1.Add a title and description for your section. 2.Choose the Tenant License History data source under the License Data data source category. 3.Select your organization and organization group, if necessary. 4.Under Select fields, choose: ·The date of the statistics snapshot ·License Name ·Assigned Units 5.This will then show the amount of licenses you currently have assigned to each license you have within your environment. However, we want to see just the license assignment of Power BI. To do this, we need to click Add filter group. 6.On Select field, choose License Name. 7.On Select operator, choose contains. 8.In Enter filter value, enter Power BI.
9.Enter your offset and limits. 10.Sort the date in ascending or descending order, depending on your preference. 11.Save your report. |
Custom table example: List of users by department
This is a continuation of a report in the charts and pivots section of this guide. Below is a step by step guide on how to view your users by their associated 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 Entra ID 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. |
Creating a custom timeline section
Which data sources are recommended for timeline charts?
Any data source which contains time-based information can be used to create a timeline chart. The following is a list of data sources that we recommend to use for informative charts:
·Office 365 Audit Data
·Office 365 Mobiles Devices
·Detailed Message Statistics
·Microsoft Entra ID Users
·SharePoint Site Usage
Here is a diagram of the required fields for a timeline report:
9.Choose your event title, event description and event date fields. Use the diagram above to help you decide which field to select in each location.
10.Optionally, select your Event category field and any fields you would like to show in detail view.
11.Decide how you would like your timeline to look.
a.You can group your timeline by day, month or year.
b.You can view your timeline as either standard or micro.
i.Standard view presents a record in its entirety, but may not be suitable for large data sets.
ii.Micro view presents all records, but individual data sets must be hovered to be revealed.
12. Add filters if required.
13. Add an offset and/or a limit.
Individual records should now look like this:
Custom timeline example: OneDrive operations
You create a section on a report that shows OneDrive operations, color-coded per operation. Here is how the finished report section looks:
Here are the steps to create this report section:
|
1.Enter a section title, for example OneDrive Timeline. 2.Choose the Office 365 Audit Data data source under the Audit Data data source category. 3.Choose and organization and group, if applicable. 4.Click the Timeline section type to begin editing the section. 5.Click the Select field... link under Choose event title field, and choose Display Name. 6.Click the Select field... link under Choose event description field, and choose Operation. 7.Click the Select field... link under Choose event date field, and choose Creation Time. 8.Click the Select field... link under Choose event category field. 9.In the Event category field, select Operation. 10.Click the Select field... link under Choose fields to show in detail view. 11.Expand the Microsoft Entra ID Users section, and choose these 6 fields: Display Name, Department, Country/Region, Operation, Result Status, and Creation Time in this order (Other fields can be added, if required). 12.Group your timeline by Day, Month or Year, depending on your preference. 13.In the drop-down list labeled Choose view type, select Micro, and enable the Show legend option. 14.Click Add filter. 15.Choose Workload is equal to OneDrive. 16.Save and close your section. |
Here is a video running through these steps.
Creating a custom map section
Using the Map report allows you to see who has logged audit data within Nova. Has there been activity in a location which is unfamiliar to your organization? The map allows you to see if there is suspicious activity occurring in locations which your company is not associated with.
Each circle is representative of audit data being logged in that specific location, which can be viewed down to street level. The shade of the circle represents the amount of logs performed at that location.
To add the map report:
9.Add a title and description if necessary.
10.For the data source, choose Office 365 Audit Data.
11.Select your organization and organization group if necessary.
12.For select field, select Geo Location.
13.Save and close the section.