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:
- Navigate to the Dashboard module of the platform
(this can be found here in the left-hand navigation menu). - 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 - 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 - 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. - Your task is complete.
Main Filters
How to filter results:
- Navigate to the Dashboard module of the platform (this can be found here in the left-hand navigation menu).
- Choose the dashboard you wish to work with from the dashboard drop-down menu (located top left of the screen).
- 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.
- Note: If there are more than 100 results available for any filter you must begin to type in order to narrow down your search.
- Note: If there are more than 100 results available for any filter you must begin to type in order to narrow down your search.
- Finally, click the Apply button at any time to apply all filters which you have selected.
Column Filters
Filter the data within a specific column.
Each column has several filter options available. Depending on the type of data that is being filtered you will be given one of the following options for filtering.
- Equals/Not Equals: Use this filter to remove certain entries from the results or to filter down to one single 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.
- Greater, Less than or Equal too: Use this filter to remove entries above or below your chosen value, or to filter down to a particlar entry.
- Group by Selection: Use this filter to group the results by one of the provided options in the drop-down menu.
Reorder Column Data
How to reorder data:
- Find the column you wish to reorder.
- Locate and click the Arrow Icon to the right of the column header to reorder the results in that column.
- 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.
