Page History
...
3. Drag the Currency Code Dimension from the Data Pane into the Filters deck. Notice that to the right a new deck appeared displaying options in the Filter for each of the Currency Codes that exist in the data.
When your Filter is a Dimension, by default, you see check boxes you can enable to show desired categories.
...
| Info |
|---|
Wildcard Match uses the following three characters as the wildcards. '?' The question mark indicates there is exactly one of missing element. For example, colo?r matches "colour" but not "color" or "colouur". '*' The asterisk indicates there are zero or more of the missing elements. For example, ab*c matches "abc", "abbc", "abdbc", and so on. '+' The plus sign indicates there are at least one of the missing elements. For example, ab+c matches "abbc", "abdbc", but not "abc". |
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 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
...
- 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. |
...
4. Drag Freight to Filters. A dialog will appear asking for the type of Filter you would like to use from a list of possible Aggregate Filters. Choose All Values.
5. Notice the Freight Filter to the right of the chart. It contains a dual slider so that you can set the range of the Freight filter.
6. In the Freight Filter deck, drag the slider on the left toward the right.
7. Drag the slider in the Freight Filter deck on the right toward the left. Notice the changes in the chart.
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 effect on the view.
Hiding and Showing Filter DecksAnchor Hiding and Showing Filter Decks Hiding and Showing Filter Decks
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.
...
- 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. |
...
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. 