Define How Values are Combined for a Bar, Column, Line, or Scatter Chart Widget

Use the Combine Values page (accessed from within the Chart Series window) to define when and how to combine negligible values (values so small that they can be ignored) in a Bar, Column, Line or Scatter Chart Widget. This is useful to remove noise values from a chart that just confuse the real data. Properties include:

  • Combine Negligible Numbers: Enables combining negligible values.
  • Values: Values to combine (example: Less or Equal to 1).
  • What to do with combined values: Hide (disregard) the values or combine them into a category in the chart (example: Other).

    The Chart Series window is accessed from within the Widget Manager when you create or edit a Chart Widget, and then add a Series.

To define how values are combined for a Bar, Column, Line, or Scatter Chart Widget:

  1. Create a Chart Widget.
  2. In the Chart Series window, click the Combine Values page.
  3. Define the rules for combining negligible values:
    1. Combine negligible values: Select this check box to enable combining negligible values.
    2. Values: Select the threshold (operator and quantity) for combining the values (example: Less than a defined quantity of 1).
    3. Specify what to do with the negligible values, either:
      • Hide these values: Select this radio button to hide (disregard) the values (they are not included in the chart).
      • Combine into category: Select this radio button to combine the negligible values into a named category, and then provide a label for the category (example: "Other").
  4. Select OK.