Filter BI Data
  • 06 Jun 2022
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Filter BI Data

  • Dark
    Light
  • PDF

A sheet in BI Analytics displays multiple data points from your Help Desk. There are numerous ways for you to filter the data to zoom in and better understand and analyze existing information.

All selected filter items are displayed on the top of the sheet.

For general information on BI Analytics, see BI Analytics.
For information on the various graphs or charts available for displaying your data, see BI Analytics Chart Options.
For information on creating dynamic presentations of your BI data, see BI Analytics Presentations.

BIDashboardfilesFilterBar.jpg

To edit a filter

  1. Click on the filter in the top bar.
  2. Click an item to select or deselect it.
    (Optional) To search for field values, click inside the field's box.
    (optional) To access filter options, click BIDashboardfileselipses.jpg.
    • (Optional) To select all of the values for a specific field, click in that field's box and click Select All.
    • (Optional) To select all possible values for a specific field, click in that field's box and click Select Possible.

(Optional) To lock the filter for further editing, click BIDashboardfilesLock.jpg. To unlock the filter, click BIDashboardfilesUnlock.jpg.

  1. Click BIDashboardfilesConfirm.jpg to confirm your selection.

(Optional) To cancel your selection, click BIDashboardfilesClearSelection.jpg.
(Optional) To cancel your selection and remove the focus from the chart, click BIDashboardfilesCancel.jpg.

BIDashboardfilesEditFilter.jpg

Select a filter entity from a chart

Perhaps the simplest way to filter your data is to select an entity from one of the charts on your screen. For example, if you have a chart that displays the top SR categories, clicking on the items that represents specific categories filters all of the data by that category.

To select filters

  1. Click the entities in a chart to highlight them and adjust the data in the other charts and objects on the sheet.
  2. Click BIDashboardfilesConfirm1.jpg to confirm your selection.
    (Optional) To cancel your selection, click BIDashboardfilesClearSelection1.jpg.
    (Optional) To cancel your selection and remove the focus from the chart, click BIDashboardfilesCancel1.jpg.

BI Analytics filtered by time to close

BIDashboardfilesFilterItem.jpg

Filter by multiple entities on a chart

You can use the lasso or chart range methods to simultaneously select multiple entities on a chart for filtering your data. When you select multiple entities they appear on the top of the screen as a single filter selection.

To select multiple entities with lasso selection

  1. Click the area of the chart you want to select items from.
  2. From the chart's menu, click BIDashboardfilesLasso.jpg.
  3. Click and drag the curser over or around the items you want to include in your filter.
  4. Click BIDashboardfilesConfirm2.jpg to confirm your selection. (Optional) To cancel your selection, click BIDashboardfilesClearSelection2.jpg.
    (Optional) To cancel your selection and remove the focus from the chart, click BIDashboardfilesCancel2.jpg.
    BIDashboardfilesLassoItems.jpg

To select items on a chart within a set range

  1. Click and drag along the axis of the chart to create a range for selection. Any items within that range are selected.
  2. If you want to expand or decrease the range, hover your mouse over one of the edges, click and drag in the direction you want.
  3. If you want to move the range, click and drag within the green area until the range covers the items you want to select.
  4. Click BIDashboardfilesConfirm3.jpg to confirm your selection.

(Optional) To cancel your selection, click BIDashboardfilesClearSelection3.jpg.

(Optional) To cancel your selection and remove the focus from the chart, click BIDashboardfilesCancel3.jpg.

BIDashboardfilesRange.jpg

Filter by SR field values

You can filter your data by any field in your help desk even if that field is not visually represented on any of your BI Analytics sheets. By default the Currently Active SRs Overview sheet is filtered by the Open SR status class.

To filter by a field value

  1. In the top-right corner of the screen, click BIDashboardfilesFieldsFilter.jpg.
  2. Locate the field and click the values you want to include in the filter.
    (Optional) To search for field values, click inside the field's box.
    (Optional) To select all of the values for a specific field, click in that field's box and click Select All.
    (Optional) To select all possible values for a specific field, click in that field's box and click Select Possible.
  3. Click to confirm your selection BIDashboardfilesConfirm4.jpg.
    (Optional) To cancel your selection, click BIDashboardfilesClearSelection4.jpg.
    (Optional) To cancel your selection and remove the focus from the chart, click BIDashboardfilesCancel4.jpg.
  4. When you have selected the values you want for the field, in the top-right corner of the screen, click BIDashboardfilesFromFields.jpg.

BIDashboardfilesFields.jpg


Was this article helpful?