Page History
Filters are possible for both Dimensions and Measures and are made by dragging one or more fields into the Filters deck.
Hiding and Showing Filter Decks
| Info |
|---|
All the filters mentioned above can be shared with all or selected worksheets related to the same data source. To know about sharing filters, see Sharing Filters. |
Dimension FiltersAnchor Dimension FIlters Dimension FIlters
To generate a view with Dimension Filters you will edit the view from the Basic View to only show data for Currency Code GBP in Profit and Deck Type.
...
4. Uncheck every Currency Code except GBP. The View will change dynamically as you make modifications to your Filter.
Top N FiltersAnchor Top N Filters Top N Filters
When a Dimension Filter is created, it is possible to select [Top N...] from within the Filter deck for that Dimension.
...
A filter with Top N (or Bottom N) limits the data included to only those items which are the indicated values for that Dimension. You can select the highest N values, the lowest N values, or both where N is a value you type yourself or pass the value using a parameter. The [Top N...] Filter dialog allows choosing between Top, Bottom, or Top & Bottom value or parameter, as well as selectively choosing a particular measure and aggregate function to be used for Top N. The bottom of the Dimension Filter deck will indicate the use and type of Top N filter.
Measure Filters (Continuous Filters)Anchor Measure Filters Measure Filters
...
8. You can change the Measure Filter from Range to [At Most] or [At Least] by clicking on the triangle at the top right corner of the Freight Filter deck then moving the single slider that appears.
Multiple FiltersAnchor Multiple Filters Multiple Filters
It's possible to have multiple Dimension and Measure Filters active simultaneously. Simply drag the Fields you wish to filter on into the Filters Deck and additional Filter Decks appear on the right for each item, which allows you to modify them separately but with a cumulative affect on the view.
Hiding and Showing Filter DecksAnchor Hiding and Showing Filter Decks Hiding and Showing Filter Decks
...
You can also hide a Filter Deck by clicking the triangle at the far right side of an individual Filter's Deck and choosing [Hide Deck].
Date FiltersAnchor Date Filters Date Filters
In Visual Analytics, you can use date fields as filters by selecting a defined range or a period relative to a specific date. Visual Analytics supports Range filters and Relative date filters.
...
| Info |
|---|
When you apply a date filter relative to Last Refresh Time, save the workbook without generating an extract and then reopen the same workbook, Visual Analytics applies filters as per the current date and time of your computer. However, when you save the workbook after generating an extract and then reopen the same workbook, Visual Analytics applies filters considering the date and time of the extracted data. For example, let’s assume today is December 6th and you reopen a workbook saved on December 1st. If you had generated an extract before saving the file then Visual Analytics applies filter relative to December 1st (date of the extract). If you had saved the file without an extract then Visual Analytics applies filter relative to December 6th. |
Keep Only and Exclude FiltersAnchor Keep Only Keep Only
The Keep Only and Exclude actions in Visual Analytics allow you to filter records from the chart view without manually adding any fields to the Filters Deck. To keep or remove records directly from the chart, highlight the specific records and then from the tooltip click Keep Only or Exclude.
For Keep Only, Visual Analytics retains the selected records in the chart view and shows these records as checked in the Filter card. For Exclude, Visual Analytics removes the selected records from the chart view and shows them stricken out in the Filter card.
...