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 Removed

You can filter in the following ways:

Table of Contents

...

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. Image Removed

...

Filter an insight by date

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

...

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 Removed

...

Dynamic periods are split into the following categories:

Category

Periods

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 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.

    Image RemovedImage Added

  2. From the Period dropdown, select Static period

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

    Image RemovedImage Added
  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 Removed) in Funnel icon in the Filters section, reveals a dropdown which dropdown which allows you to exclude any of these attributes or the Date measure, by deselecting the checkbox next to it.  Image Removed

...

Info

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

Image Modified

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. 

    Image RemovedImage Added
  2. Click Add attribute filter

    Image RemovedImage Added


    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. 

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

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

    Image RemovedImage Added