Vizlib Filter Properties - Dimensions, Data Handling

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

• Dimension
• Filter Values
• Measure
• Indicators
• Markers
• Sort Options
• Data Handling

Dimension

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

Back to Contents

Filter Values

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

Back to Contents

Measure

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

Indicators

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

Back to Contents

Markers

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

Back to Contents

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

Back to Contents

Sort Options

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

Back to Contents

Data Handling

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

Back to Contents