Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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
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.
1. Begin by dragging Card Type from Dimensions into Columns.
2. Then drag Profit into Rows. Notice the state of the chart.
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.
Clicking the triangle to the top right of the Dimension Filter deck presents several ways of selecting which categories in a Dimension are part of the Filter:
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 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 or the lowest values N values, where N is a value you type yourself. The [Top N...] Filter dialog allows choosing between Top or Bottom, 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)
To create a Measure Filter (or to create a Continuous Filter), drag a measure or continuous field into the Filters Deck. Continuous fields are always indicated by a green color or green background. Measure Filters produce sliders in a deck to the right of the view that allow filtering for:
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.
To create a view with a Measure filter for Freight:
1. Remove all of the Fields from the Columns, Rows and Filters decks from our previous example.
2. Drag Card Type to Columns
3. Drag Profit to Rows
4. Drag Freight to Filters.
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 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 Decks
Filter Decks can be hidden by either right clicking a filter's name in the Filters deck and 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 Filters
Date Filters can be altered to show Year, Quarter, Month, Week Number, Week Day, Day, Hour, Minute or Second. To change a Date Filter, right click on a date or datetime datatype field that is present in the Filter deck. By default, Date is treated as Continuous data but can be presented in a variety of ways via the various Date Groupings available for Date/Time datatypes. Choose the desired Date format from the dropdown. The formats listed at the top of the Date Groupings menu will automatically provide Discrete filters for date. The formats listed in the bottom half of the menu will automatically provide Continuous date filters. It's also possible to individually select Discrete or Continuous and pick any format listed, or write your own custom date format with [Format... > Custom]
If (null) dates need to be removed from a chart, drag the relevant date field into the Filters deck, then click the menu triangle in the Date Filter and uncheck [Include Null Values].