In the property panel, the Dimensions menu is where you define your filter field, which can be a single dimension, a drilldown or a master item dimension. In this example the values in the Clothing table are filtered against CategoryName, and you select, deselect and display them in the Sales YTD Mini Charts (Figure 1). You can find an example filter setup in our guide here.
Figure 1: Filter Example
TABLE OF CONTENTS
In the Field section (Figure 2) you can define the field name, title and select whether to include null values or a limitation.
Figure 2: Dimensions
In Filter Values (Figure 3) you can choose to hide or show dimension, and also make them subject to a condition by entering an expression in Conditional Show exp. for Values. If the condition value is true, the value will be displayed.
Figure 3: Filter Values
You can also select to display a Frequency Count for the dimension (Figure 4), choosing from the Absolute value, Percent or Relative value. Figure 5 shows the frequency count as a Percent with 8 Categories representing 12.5% each of the available values.
Figure 4: Frequency Count
Figure 5: Frequency Count Example
Enabling the Measure settings (Figure 6) allows you to add a measure to the filter. You can add a measure expression, and this example uses =sum([Gross Profit])/sum(Sales). You can also select a method of Measure Formatting and Format Pattern.
Figure 6: Measure
The Indicators settings allow you to display an indicator next to the measure (Figure 7), and also customize the indicator shown when the measure is compared to a pre-defined threshold. You can enter the value in Indicator Threshold (this example sets the threshold at =20/100 or 0.2).
Figure 7: Indicators
The icon and color indicators (Figure 8) can now be set, and they are displayed according to the result of comparing the measure value to the threshold (Greater than, Less than, Equal than). You can choose to show or hide each icon, and also set the Icon Position.
Figure 8: Indicator Icons
Markers can be enabled to display a symbol beside filter values (Figure 9). You can choose from 2 Representations - Icon or Image. You can also customize the Symbol Size and Symbol Opacity, and choose to Show Dimension Values (when Disabled, only the icon or image will be displayed).
Figure 9: Markers
If you choose Image as a representation, enter the image location and any further settings in Image expression. Figure 10 shows an example of filter values which uses images of flags.
Figure 10: Image Markers Example
Sort Options allow you to choose how filter fields are sorted (Figure 11). You can sort in ascending or descending order, sort by state, sort in alphabetical order (or reversed) and by original load order (or reversed). #1 Sort by State is the default sort option.
Figure 11: Sort Options
Data Handling settings (Figure 12) contains settings relating to the data in the object. You can enter a Calculation condition using the editor, and also enter a message to display if the calculation is not fulfilled
Figure 12: Data Handling