Vizlib Home Try Vizlib

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

Vizlib Bar Chart supports using one dimension with multiple measures or two dimensions with one measure. 


Data - Dimensions and Measures

Add dimensions and measures in the Data section using Fields and Master Items and use alternative dimensions and measures to offer more options for analysis; see an example in our article on creating a bar chart using the wizard

Adding Dimensions 

  1. From the Data section, click Add in the Dimensions section (Figure 1).
  2. Set the Field and Label, and click in the checkbox if you want to Include null values.
  3. Use the Calc. condition field to specify a conditional expression to show or hide the dimension when a condition is met. 

Figure 1: Dimension

Back to Contents

Adding Measures

  1. From the Data section, click Add and drag the option down to the Measures section. 
  2. Enter the type of measure in the Expression field (Figure 2).
  3. Enter the measure's name in the Label field.
  4. Select a Number formatting option from the list: Auto, Number, Money, Date, Duration, Custom, or Measure expression.
  5. Set custom Formatting to set a Format pattern.
  6. Use the Calc. condition field to specify a conditional expression to show or hide the measure when a condition is met.

Figure 2: Measure

Using Master Item formatting with Measures

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

This can help you apply formatting quickly across multiple charts when you slide the Master measure formatting toggle to the right. 

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).
  • Select Include only bars (only show totals for measures represented as bars when Show totals on Stacks is selected).
  • Select Show all values, or Show only totals.
  • Enable Custom Tooltip to use your own HTML code for the tooltip.

Figure 4: Bar Color, Data Values, Custom Tooltip

Back to Contents

Setting Sorting options

The Sorting tab controls how you order your data (Figure 5) and has a default setting of Auto for both dimensions and measures. 

Switch to Custom sorting to set your own values and sort by expression, numerically or alphabetically. 

Figure 5: Sorting

Back to Contents

Applying Data Handling options

Data Handling options (Figure 6) allow you 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.
  • Enter a custom Displayed message.

Figure 6: Data Handling

Back to Contents

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