Vizlib Bar Chart Properties - Data - Dimensions, Measures - Data Handling, Sorting

Vizlib Bar Chart supports either one dimension with multiple measures or two dimensions with one measure. You can add dimension or measures in the Data section using Fields and Master Items, and also choose to add alternative dimensions and measures. In this article we're using settings for fields. If you'd like You can find an example of adding dimensions and measures to create a bar chart using the wizard here. 

TABLE OF CONTENTS

• Dimensions 
• Measures
• Data Handling
• Sorting 

Dimensions 

When you add Dimensions (Figure 1), you can You have the ability to Include null values, set a Limitation and specify a Calculation condition, where the dimension is only displayed if the condition is met.

Figure 1: Dimension

Back to Contents

Measures

When you add Measures (Figure 2), you can enter an Expression, add a Label and select a Number Formatting option. You can also set customize Formatting to set a Format pattern and specify a Calculation condition, where the measure is only displayed if the condition is met.

Figure 2: Measure

If the measure has been created from a Master Item (Figure 3), you can choose to enable Master measure formatting, which means formatting for the measure will be taken from the master item definition (you can find master items in the Custom Objects menu in the left hand panel).

Figure 3: Master Measure Formatting

You can also specify a Bar Color, set the Bar Opacity, show or hide Data Values (you can choose to Show totals on stacks in a stacked chart, Include only bars (only show totals for measures represented as bars when Show totals on Stacks is selected), Show all values, or Show only totals), and enable Custom Tooltip to use your own HTML code for tooltip.

Figure 4: Bar Color, Data Values, Custom Tooltip

Back to Contents

Measures - Master Item

Back to Contents

Data Handling

Data Handling (Figure 5) gives you the ability to pre-define Data downloading within the chart (by default, this is limited to the first 5000 rows), Suppress Zero Values, Show/Hide the chart depending on a Calculation condition, and enter a custom Displayed message.

Figure 5: Data Handling

Back to Contents

Sorting 

The Sorting tab controls how you order your data (Figure 6) and has a default setting of Auto for both dimensions and measures. You can switch to Custom sorting if you'd like to set your own values and sort by expression, numerically or alphabetically. 

Figure 6: Sorting

Back to Contents