Filters

Spearline provides powerful filters that can be applied to test results to present data in various ways. Use filters to find meaningful patterns in your test results and to highlight various issues to your relevant teams.


Date Range

Filter results by date using the date range selector

How to filter by date:

  1. Navigate to the Dashboard module of the platform  (this can be found here in the left-hand navigation menu).
  2. Choose the dashboard you wish to apply the date range to using the dashboard drop-down menu(located top left of the screen).
    Figure: Dashboard selection drop-down menu
  3. Once the dashboard has loaded, click the Date Range selector to set your desired date range (this is located top left of the screen).
    Figure: Date range selector
  4. Choose the date range you would like to view using one of the below options.
    • Predefined Date Range – These are presented as a list on the left of the panel and will automatically re-load the dashboard data when chosen.
    • Custom Date Range – These can be added using your mouse or trackpad to select a start date, followed by an end date. You may also choose to set a start/end time but this is optional. You must click Apply afterward to re-load the dashboard data.
    Note: If you prefer, you can enter the start and end range directly in the format shown at the top of the panel. You must click Apply afterward to re-load the dashboard data.
  5. Your task is complete.
Results: The dashboard will now reflect the data specific to the date range you have selected.

Main Filters

The main filters can be used along with the date range filter to narrow down your search results and show you more relevant results. 

How to filter results:

  1. Navigate to the Dashboard module of the platform  (this can be found here in the left-hand navigation menu).
  2. Choose the dashboard you wish to work with from the dashboard drop-down menu (located top left of the screen).
  3. Use the drop-down menus provided for each option to search and select your desired filters. When done choosing from a list, click the Confirm button or anywhere outside of the menu to close the menu.
    Figure: Numbers filter
    • Note: If there are more than 100 results available for any filter you must begin to type in order to narrow down your search.
  4. Finally, click the Apply button at any time to apply all filters which you have selected.
    Figure: Apply Filters
Results: Your filtered data will now be displayed.

Column Filters

Filter the data within a specific column.

Each column has several filter options available depending on the type of data.

Equals/Not Equals: Use this filter to remove certain entries from the results or to filter down to a particlar entry.

Show/Hide, or Remove data cells: Use this filter if you wish to view or remove empty cells from the table that do not contain information. This will only apply to the column where you set the filter.

Group: Grouping is a powerful feature that can be used on its own or in tandem with other filters to present information from a birds eye view. Grouping is most powerful when used with the ‘Totals’ data column and any other data columns that offer a percentage value. When these columns are added grouping can provide great insights into how well a country or number is performing or to the extent of their issues. To show or hide data columns, see Custom Dashboards.

More or Less than: Use this filter to remove entries above or below your chosen valueor to filter down to a particlar entry.


Reorder Column Data

Reorder data within a column to show results in ascending or descending alphabetical order.

How to reorder data:

  1. Find the column you wish to reorder.
  2. Locate and click the Arrow Icon to the right of the column header to reorder the results in that column.
  3. Your task is complete.

There are 3 available options for reordering the results in a column.

  • No Order

    Noted with an arrow pointing in both directions.

  • Ascending

    Noted with an arrow pointing up.

  • Descending

    Noted with an arrow pointing down.


Was this article helpful?

Related Articles

Need Support?

Can't find the answer you're looking for?
Contact Support