Vizlib Home
Welcome
Login

Vizlib Filter Properties - Dimensions

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). 


Figure 1: Filter Example


TABLE OF CONTENTS



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


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


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). 


Figure 8: Indicator Icons


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.


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


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





M
Martin is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.