Creating a custom chart widget
Adding a custom chart widget to your dashboard follows similar steps as creating a section of a chart and pivot report, which will be covered later. This section will appear on your dashboard, which you can customize to your needs. To do that:
1.On the dashboard, click Edit in the top right hand of the screen.
2.Click Add widgets, then Configurable Chart Widget.
3.Enter a Widget title and a Widget sub-title if appropriate. Optionally, you can link your widget out to a report from within the Report Center.
4.Select a data source from the drop down list.
5.Select an organization and organization group, if applicable to your environment. These help to narrow down the scope of your reports.
6.Select a chart type. You can read more about chart types in the Quadrotech Nova Reporting Guide.
|
|
NOTE: Only charts and pivots can be created for use in the dashboard. To create a report using any type of data presentation, use the Report Center. |
7.Once you have selected your chart, choose an Operator. Operators are:
a.Average: This is calculated by dividing the total of all of the values by the number of values.
b.Count: The quantity of values in a data set.
c.Sum: The result of adding together the values in a data set.
d.Min: The smallest value.
e.Max: The largest value.
8.Select an Applied to data field. This is your Y axis. You can use the search boxes to find the exact data field you need, or filter by data type or data source.
9.Choose a Series name data field. This is your X axis. You can search for this the same way as the step above.
10.Optionally, choose a category. You can search for this the same way as step 8.
11. Add a filter group, if desired. Filtering allows you to narrow down the scope of your report. For example, you may only want to view users within a certain department or geographical location.
12.You can sort your data, if needed. Similar to step 8, you can search for a data field you would like to sort by ascending or descending order.
13.Set an offset. This is the starting record of your widget.
14.Set a limit. This is the maximum number of records returned within your widget.
|
|
NOTE: When downloading a section, this limit is ignored. |
15. Select or deselect Overflow. This gathers data outside your limit into one section of a chart.
16.Choose your drill down fields.
17.Click OK, and your widget should appear in the dashboard. Click Save in the top right hand corner to finish the section.
Adding a card widget
If you would like to see a card presented on your dashboard, follow these steps:
1.From the dashboard, click Edit in the top right hand of your screen.
2.Click Add Widgets and select Card Widget.
3.Name your widget, and give it a title if necessary.
4.Create your card as you would with the steps above, and click OK.
Your card should now appear within the dashboard. If you have set analytics on your card, your card should display the color affiliated with the analytic you inserted.
|
|
NOTE: You are able to move your card in the dashboard to a place of your convenience. Also, you are able to resize the widget to your standards. For more on Nova dashboards, click here. |
Nova Report Center
Microsoft has several different interfaces for tools used to perform Office 365 management, reporting, and auditing tasks. In contrast, Nova users perform that work in a single user interface.
To achieve this, Nova gathers reporting and auditing data from Office 365. Reporting data is collected about every 24 hours and auditing data is received from Microsoft when it becomes available. This data is stored in Nova for as long as the organization remains a subscriber, which is much longer than Microsoft typically stores this data in Office 365.
The flexibility and power of the Nova Report Center is ideal for organizations with custom reporting needs that can not be fulfilled by the standard reports available in Nova. To create a report with the Report Center, you specify:
1.How you want the report to look. You decide what sections the report contains. Will it have charts, graphs, maps, or tables that will display the information?
2.The types of data the report will display. These are called data sources.
3.Any filters you want to apply against the data sources. For example, your data source might be a list of Azure AD users. You might want to filter that list, so your report only shows users in North America or a certain department.
Just like other Nova reports, the reports created using Report Center can be saved, scheduled, and shared. If you do not want to build an entirely new report, you could even clone an existing report and customize it to meet your new needs.
Below is an example of a report built using Report Center.
Report Center terminology
If you are just getting started with the Nova Report Center, you may be unsure of some of the words and phrases that you encounter. Below are some common words and phrases related to Nova Report Center, along with descriptions.
It is important to differentiate what is meant between a section of a report and the report itself.
·A Section of a report are the individual charts, graphs and tables themselves. You can have one or multiple sections in a report.
·A Report is where individual data sections can be created, modified and stored.
Data sources
Data sources drive reports. They are the sets of information used to build reports. Choose a data source that is representative of the type of data you want to display. If you can not decide on a data source, you can clone one of the system reports to get started. To see more on data sources, click here.
Organization
You can narrow the scope of your report to a specific organization within your tenant.
Organization Group
Select an organization group to further narrow the scope within your report.
Add Aggregation
For table reports, you can aggregate fields to get a specific count for that field. For example, let us say you want to quickly see how many Azure AD users have been assigned to each department within your organization. You can do this by selecting Department as your table field, then select Add aggregation, then choose Display Name with Count as your operator. The amount of users within each department displays. This is useful if you need to know the number of objects within a data field.
Add Filter and Add Sorting
Filters and sorting are explained above. Note that you can use up to 5 filters within each section of your report. To learn more about filtering, click here.
Offset
Set the starting record by applying an offset.
Limit
This is the highest number of results shown within the report. For example, if you have a limit of 20, then 20 entries display. Note that if you choose to download your report, the limit will be ignored and all data is shown.
Enable Paging
Useful for large data sets, paging allows you to see a select number of results per page before you need to move to the next page for more results. If this is disabled, all data displays in one table without having to page through results. If the report is downloaded, it will not be organized into pages.
Overflow
It is likely that your pie/bar chart will have a lot of data to show, resulting in a complex report that's not easy to analyze. Overflow aggregates calculations outside of your limit into one specific bar or pie wedge. For example, if you have a limit of 6 wedges or bars, any data from outside of your 6 biggest wedges or bars will be calculated and formed into one bar or wedge.