Page History
...
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.
...
- A Range of Values
- At Least a Value of
- At Most a Value of
| Info |
|---|
By default, any Measure field dragged and dropped into the Filters Deck is converted to a Continuous Dimension within the Filters Deck. It is possible to right-click and convert a Continuous Dimension back to a Measure while it is inside the Filters Deck to create a filter that takes into account its [Default Properties > Aggregation] such as SUM or COUNT or Std. Dev. You can also right-click a Measure field present in any deck except the Filters deck and choose [Show Filter] to have the measure's [Default Properties > Aggregation] used in a filter. |
...
Filter Decks can be hidden by either right-clicking a filter's name in the Filters deck or unchecking [Show Filter]. To show a Filter Deck once it's hidden, right-click on the Filter and check [Show Filter].
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.
...
Use this filter to specify a fixed date range. For example, if you want to project the sales for your products from March 1, 2015, to December 31, 2018. You can apply this filter only to continuous date and date and time dimensions.
To apply Range filters
- In the Filters Deck, place a date or date and time dimension.
- In the Filter field window, choose Range of dates. Visual Analytics displays the range on the right side of the chart view.
You can add an extra filter to the range of dates by defining a starting or an ending date. The starting dates let you modify the start dates in the range, but the ending dates cannot be modified. Likewise, the ending dates let you modify the ending dates in the range, but the starting dates cannot be modified. You can modify these dates by moving the slider.
...
- In the Filters Deck, place a date or date and time dimension.
- In the Filter field window, choose Relative date.
- Click on the Filter Card to view the date units.
Date Units
The Filter Card contains tabs for various date units. You can switch to the date unit tab to which you want to apply a date filter. You can apply a date filter to date units that are Years, Quarters, Months, Weeks, Days, Hours, Minutes, Seconds. 
Date Range
You can apply a date range based on the previous, next, or current period. You can also manually set a range in the Last or Next combo box, or use the Month to Date option if you want to see the data from the first date of the month until the current date of your computer. The date range that you apply appears at the bottom of the Filter Card. In the following example, to view the sales report for the current and previous months, we have set Last as 2 months. The applied date range can be seen at the bottom of the card.
Anchor Relative To
By default, Visual Analytics applies filters relative to the date and time you last refreshed or extracted data source. However, when you set a date in the Anchor Relative to field, Visual Analytics applies a filter relative to the specified date. For example, to analyze sales targets for the last 4 quarters ending on March 31st, 2016; switch the date unit to Quarters, set Last as 4 quarters, and set Anchor Relative to March 31st, 2016. Visual Analytics displays the sales targets from April 1st, 2015 to March 31st, 2016.
| 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.
| Keep Only | 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.
An alternative way of filtering records is via the Color and Shape legends. In color or shape legend, click the records you want to keep or remove from the chart view and then click Keep Only or Exclude from the tooltip.
If you have multiple dimensions in a chart view, and you click Keep Only, Visual Analytics displays an Inclusion filter in place of the usual filter. An inclusion filter lists the combinations of all records of the dimensions in use, with selected records as checked. For example, when you highlight the shipping methods with the highest freight value for each state and then click Keep Only from the tooltip, Visual Analytics keeps the highlighted records in the chart view and removes others. In the Inclusion filter, it shows all the highlighted records as checked.
...
Similar to the Inclusion filter, when you click Exclude, Visual Analytics shows an Exclusion filter with all the highlighted records stricken out from the Filter card. 