Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Image Modified

You can:

Filter an insight by attribute

Drag any of the available attributes from the Data 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 the Data 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.
Image Modified

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. 

Image Modified

Dynamic periods are split into the following categories:

CategoryPeriods
Day
  • Last 7 days
  • Last 30 days
  • Last 90 days
Month
  • This month
  • Last month
  • Last 12 months
Quarter
  • This quarter
  • Last quarter
  • Last 4 quarters
Year
  • This Year
  • Last year

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 (Image Modified) 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. 

 

Info

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. 


Panel

On this page:

Table of Contents