This is where you perform a quick keyword filter, or access the Focus and Advanced filter features.
Focus
Select data what about this first?
The Focus tool displays a subset of your data in the grid. After you select one or more rows of data, you can use the Focus tool to isolate those selected rows from the rest of the dataset. You can then take your analysis further, concentrating on those specific rows of data.
Select the row(s) you want to focus on, then click the Focus button.
The grid updates to display only your selected rows. Any totals or averages that display in the updated grid now relate only to the selected rows of data. The status bar above the grid identifies the selected data. The number of rows you have focused on displays in brackets on the corresponding dimension (which displays in blue).
to undo the focus action and revert to the full list of rows in the grid:
(Optional) Click the Select button in the top-left corner of the grid to retain your row selections when you revert to the full list of rows*.
Click the X on the corresponding dimension button.
| Info |
|---|
*Your selections might not always display on the screen; they might be listed on another page of the grid. You can move through the pages to find them. |
not available?
Filter box
...
| Info |
|---|
The filtering options in Flexible Variance are similar to those in the other modes. This page provides links to related documentation pages, but please keep in mind that there might be some differences there. The significant differences are explained below. |
There are four ways to filter the data in Flexible Variance mode: Focus tool, filter box, right-click filter and advanced filter.
When you filter data using any of these methods, chips appear in the right side of the filter box to help you keep track of what you've done. When there are two or more applied filters (chips):
The And indicator informs you that the AND condition is applied to the filters. You can change this to an OR condition the Advanced filter panel.
The Clear button allows you to instantly clear all your filters and return to the default view of the data.
1. Focus tool
The Focus button allows you to view a subset of your data in the grid. Select one or more rows in the grid to activate the Focus button, then click it to filter out all the other data. Your filter displays as a chip on the right of the filter box.
While the focus tool currently works differently from other modes, you might find these pages useful:
Select data. Currently, is isn’t possible to select multiple separate rows, but you can click and drag to select multiple consecutive rows. Also, when you select a row on one page of the grid and then move to another page, you lose your first selection.
Focus on data. Currently, it isn’t possible to exclude data or lock selections.
2. Filter box
The filter box sitting directly above the grid allows you to you perform a quick a keyword search to filter the grid.
Type a keyword into the box and press Enter. This action automatically performs an
...
...
...
...
...
...
...
...
Right-click a cell in a column to display the context menu, then select the filter you want to apply.
...
...
...
when you click the Advanced filter button, a panel opens showing any filters you've applied using any of the three other filtering methods. In other words, you’ll see any keywords you’ve entered in the filter box, entities you’ve focused on, and conditional filters you’ve applied via the right-click menu. If you have applied two or more filters, you can switch between using and AND or OR condition.
In a future release, you'll be able to perform more advanced filtering based on conditions and using groups.
On this page
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|