How to Use Scopes on a Data View
This lesson explains how to use Scopes on a data view.
Navigate to a Data View that Uses Scopes
Navigate to any data view that uses Scopes. For a non-admin user, data views that have had one or more Scopes applied appear this way in the user interface when first opened. No data will be shown until the user fills out any required Scopes and clicks Run in the scopes panel on the right.
Populate the Scopes Filters
- To populate the data view the user should select (in this case) a from and to date and/or a Core Count range
- and click the Run button. This will load the data view as normal, but only with data that meets the Scopes criteria.
If there is more than one Scope in a data view, they can also be populated to further limit the data returned.
Potential Error Message
If you do not fill out all of the required Scopes filters then you will see this error message pop up. You can resolve this by populating that Scopes field and re-running the filter.
Returning All Data
A data view with one or more Scopes filters (that are not required) that is run without any input returns all data, as though the Scopes had never been applied to the data view.
Scopes Ran on an Aggregated Column
When Scopes is used on data views with aggregated columns only the number that appears in the aggregated column gets affected. Above is an example of a Scope that is filtering a field from an aggregated column. Free Disk Space is actually a field from the table Installed Disks which is used for the aggregated column.
The number of records on the current data view do not change because this filter is actually applied to the Installed Disks table that was used for the aggregated column. After the data in the Installed Disks table has been filtered, then the aggregate function (count, max, sum, etc.) is ran and the result is displayed in the aggregate column.