Filters in the Analyzer tool

The Filters section allows you to apply filters to an insight in the Analyzer tool.

Filter an insight by attribute

Drag any of the available attributes from theData Catalogue, into the Filters box. For example, you might want to filter an insight so that it only includes data related to certain communities, users, departments, job titles and so on. 

Filter an insight by date

Drag the Date measure from theData Catalogue into the Filters box. For example, you might want to filter the data shown in the insight, so that it is from a specific date/time period.

There are two types of time period in the Period filter:

Dynamic periods

You can filter an insight so it shows data from a predefined period, such as the last 7 days, last month, last quarter, last year, and so on. With the exception of the Static period option, all time periods in the Period dropdown are dynamic, meaning the dates associated with the period will change with the passage of time. 

Dynamic periods are split into the following categories:

Static periods 

You can filter an insight by choosing two static calendar dates. Unlike the dynamic time periods listed above, a static time period does not automatically changed based on the passage of time. Once two dates have been chosen, they will remain the same, unless the dates are manually altered.

Being able to choose static dates can be incredibly useful, if you want to show data from a specific week, month or quarter several years in the past. 

To select a static time period: 

1. In the Filters section, click the Date dropdown.
   

   

2. From the Period dropdown, select Static period. 

   

3. Select the dates on which the period will start and end.

   

4. Click Apply.  

Include/exclude selected measures and the Date filter

When an attribute or the Date measure is dragged into the Filters section, it is automatically applied to the data in your insight. Clicking the Funnel icon in the Filters section, reveals a dropdown which allows you to exclude any of these attributes or the Date measure, by deselecting the checkbox next to it. 

To completely remove an attribute or the Date measure from the Filters section, you can drag it back into the Data Catalogue. 

Filter measures in the Measures section

You can filter any of the measures you have dragged into the Measure section by adding an attribute. For example, you can might want to filter the Content Views measure by Department, Learning Plan Id, location and so on. 

To filter a measure: 

1. In the Measures section, expand the measure. 

   

2. Click Add attribute filter. 

   

   
   A dropdown appears, containing a list of attributes that are related to the measure. For example, for the Content Views measure, you will find content related attributes by which to filter it, such as Content Id, Content Title, Topic Id, and so on. 

   

3. Select an attribute from the dropdown and it is added to the measure. 

   

4. Click on the attribute and a dropdown appears, where you can refine the attribute by deselecting checkboxes.