Chat now with support
Chat with Support

Welcome, erwin customers to Quest Support Portal click here for for frequently asked questions regarding servicing your supported assets.

Quadrotech Nova Current - User Guide

Overviews Adoption Accelerator Delegation & Policy Control (DPC) Reporting TMS Settings About

Filtering and Sorting

Filtering your charts and tables and dates is easy to do within the Nova Report Center. You are able to search within very specific time frames for a variety of data sources and data source categories.

To filter your data to within certain time frames:

1.Go to your chosen report that you have already created, or begin by building one. Ensure that your report is one in which date is a valid property.

2.Go to Add filter group.

3.In Select field..., select the date property. This could take multiple forms, including Date, Activity Date, Created Date Time. Deleted Date Time, and so on. This depends on which data source you have selected.

4.Then select the parameters of your date filtering.

a.With is newer than, these are dates AFTER your parameters. For example, is newer than 1 year is within the past year up to this point.

b.With is older than, these are dates BEFORE your parameters. For example, is older than one year includes dates before the past year, not including the past year.

You are also able to add another filter so you can include dates within a specific time frame i.e. between 30 and 60 days. This is possible by clicking the plus button and repeating the steps above. Ensure that you have selected AND, rather than OR, if you are filtering between two dates. This can be seen in the image below.


NOTE: A maximum of 10 filters can be added to a section of a report.

Filtering by QTD/YTD

It is possible to search within Quarter to Date (QTD) and Year to Date (YTD) metrics within the Nova Report Center for date-specific data fields.


The QTD parameter gives you data from the beginning of the current quarter, and ending at the current date.

The YTD parameter gives you data from the beginning of the current year, and ending at the current date.


For example, perhaps you want to see the amount of Azure AD users created within the current year within your tenant. To do this:

1.Begin by creating a new report, including title and description if necessary.

2.Choose your data source. For these specific filters, you will need sources that include date data fields. For our example, we are using Azure AD Users.

3.For Table fields, choose Display Name and User Created.

4.Under Add filter group, select is during, then YTD.

5.Add sorting and change your offset and limits if required.

Below is an example of what your report should look like.




You can sort in ascending and descending order for any data field, even fields that you have not included in your report section. To add a searching parameter:

1.In your report section, click Add sorting.

2.Select the data field you would like to sort by.

3.Choose between ascending (smallest to largest, A-Z) and descending (largest to smallest, Z-A).

Alternatively, you can click on the heading of a table section to sort that specific field.

Why a Report may have no Data

You may come across the notification ‘There is no data for this chart‘ as you are building a report.

There are a few reasons for this, including:

·The data is being filtered in a way that no data is returning. You may need to edit your report and modify your filters that you have applied.

·The data may require access to the Security and Audit Logs that may not have been configured. Check your Nova settings in inquire about this.

·The data has not been collected as the data collection needs to be authorized.

You may need to  your tenant. For steps on how to do this, check out this article.

If you have completed these steps and still have the notification and/or there is still no data being presented in your report, please contact support about your issue.

For more information on the Nova Report Center, click here.

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.

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.


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.


Set the starting record by applying an offset.


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.


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.

Data Sources

Reports built using the Nova Report Builder contain information from from various data sources. For example, reports might contain data related to Microsoft Teams, Yammer, Skype, and more. Additional data sources will be added over time.

A data source is a specific subset of data fields that are collected into a grouping for report creation.

Here is an example. In the menu, data source categories are shown in blue and the actual data sources are shown in black.



As you see in the image above, data sources are separated into categories. Here is more about each category:

Data Source Category


Data Sources

Adoption Accelerator

This includes data related to Nova Adoption Accelerator campaigns.

Adoption Accelerator Campaign Activity

Adoption Accelerator Campaign Members

Adoption Accelerator Campaign Notifications

Adoption Accelerator Campaigns

Alert Data

This includes data based from alerts from the Notification Center.


Audit Data

This is audit data relating to Office 365.

Office 365 Audit Data

Beacon Data

This is data relating from beacons within Service Monitoring.


Beacon Log Data

This is data relating from the beacon log within Service Monitoring.

Beacon Log Data

Campaign Data

This is data relating to an Adoption Accelerator campaign.


Exchange Data

This is data relating to your Exchange environment, including data sources for Mailboxes and user activity.

Exchange Cliant Access Settings

Exchange Recipient Attributes

Exchange User Activity Aggregate

Mailbox Permissions

Office 365 Mail Traffic

Office 365 Mailbox Statistics (Daily)

Office 365 Mailboxes

Office 365 Messages Monthly

Public Folders

User Message Statistics (Aggregated)

User Message Statistics (Daily)

License Data

This is data for your license management in your environment.


Tenant License History

Tenant Licenses

User Licenses

User Service Plans

Mobile Data

This includes data for mobile usage, including devices used by your users and applications downloaded.

Intune Audit Events (Preview)

Intune Detected Applications (Preview)

Intune Managed Devices (Preview)

Intune Managed Windows Devices (Preview)

Office 365 Mobile Devices

Office 365 Data

This is data in relation to your Office 365 environment, including Azure groups and members, as well as subscriptions.

Azure Group Members

Azure Groups

Azure Users Activity by Service

Office 365 Service Status

Office 365 Status Overview

Office 365 Subscriptions

Role Group Members

Role Groups

Tenant Details

User Product Activations

OneDrive Data

This is data about your OneDrive environment.

OneDrive Tenant Activity

OneDrive User Activity Aggregate

OneDrive User Statistics

Organization Data

This is data relating to your organization in the Tenant Management System.


NOTE: You may see restricted data sources depending on your role within Nova.


Organization Type

Service Account


Subscription Item


This includes data about licenses and sign-ins.

Azure Sign Ins

Latest Data Collection Results

Office 365 Licenses

Score History

SharePoint Data

This is data about your SharePoint environment.

SharePoint Library Settings

SharePoint Site Usage

SharePoint Sites

SharePoint Sites and Libraries

SharePoint Tenant Activity

SharePoint User Activity Aggregate

Skype For Business Data

This is data about your Skype for Business environment.

Skype Activity History

Skype User Device Usage History

Skype for Business Tenant Activity

Skype for Business User Activity Aggregate

Teams Data

This is data about your Teams environment.

Azure Group Members (Preview)

Azure Group Owners

Microsoft Teams

Teams Channels

Teams Installed Apps

Teams OneDrive Storage

Teams Tenant Activity History

Teams User Activity Aggregate

Teams User Activity History (Preview)

Test Result Log Data

This is data relating to Service Monitoring.


Workload Data

This is data relating to specific workloads in Service Monitoring.


Workload Log Data

This is data relating to Service Monitoring.


Yammer Data

This is data about your Yammer environment.

Yammer Tenant Activity

Yammer User Activity Aggregate

User Data

This includes Office 365 user-related data. For example, display names, job titles, location, etc.

Azure AD Contacts

Azure AD Users

Azure AD Users Usage Statistics

Azure MFA/SSPR (Preview)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating