Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Chart Options for Analyzer reports

Parent article

The Chart Options dialog box is available if you have a visualization applied to your report. Click Chart Options in the Properties panel to bring up the chart options for that report. You can click Apply to update your report with your changes up and continue working with the Chart Options. After setting options for your chart, click OK. The report will refresh to reflect the options.

General tab in Chart Options

The General tab is where you can set background colors, fonts, or the domain limit for the maximum number of plot values for your report.

General tab in Chart Options

Fill in the following options for your chart in the tab:

OptionDescription
Background

Fill type defines the background color of the chart and the fill colors used.

Select None, Solid, or Gradient with the drop-down menu.

Labels Use the drop-down menus to choose a font for your data labels, specify the size and type for the font, and change the font color with the color picker.
Domain Limit Max number of plot values: Use this to set the maximum number of plot values used in your report.

Axis tab in Chart Options

The Axis tab is where you can define how the x-axis and y-axis appear on your report.

Axis tab in Chart Options

Fill in the following options for your chart in the tab:

OptionDescription
Primary AxisAuto Range check box: Calculates the Start and Stop value automatically. If you want to specify the values, uncheck the box and fill out the Start and Stop fields.
  • Start: Use to set the starting value for the axis.
  • Stop: Use to set the stopping value for the axis.
  • Scale: Increase the scale for the primary axis, or leave it set to a default of None.
Secondary AxisAvailable for Scatter and Column-Line Combo charts only. Secondary Axis has the same options as Primary Axis.

Legend tab in Chart Options

Use the Legend tab to customize the look of the legend of your report.

Legend tab in Chart Options

Fill in the following options for your chart in the tab:

OptionDescription
Show legendClear this box to remove the legend from your report.
PositionUse the drop-down to move the legend to the Top, Right, Bottom, or Left of your report.
Background colorUse this to change the background color of the legend. Click on the Background Color box to bring up the color picker.
FontUse the drop-down menus to choose a font for your data labels, specify the size and type for the font, and change the font color of the legend.

Other tab in Chart Options

Use the Other tab to tailor the look of the small charts for your report, if you have the Multi-Chart option selected. You can alter the size of negative values, or specify how you want Analyzer to show empty cells in your report.

Other tab in Chart Options

Fill in the following options for your chart in the tab:

OptionDescription
Multi-Charts

Charts Per Row: Select from the drop-down menu to specify how many multi-charts on each row appear.

Scale: Use the drop-down menu to set the axis range for your multi-charts. You set the same range for all of the small charts or set them independently.

Size By Measure

Treat negative values as: Use the dropdown menu to choose either Smallest Value or Absolute.

Empty cell treatment (Line and area charts only): Controls how empty cells appear in your Line and Area charts. Choose from Show Gap, Connect with Dotted Line, or Treat as Zero.

Advanced tab in Chart Options

Use the Advanced tab to configure visualization views at the report-level using configuration rules.

NoteThe configuration rules are limited to using a JSON syntax.
Advanced tab in Chart Options

Procedure

  1. Click the Help icon icon to open the Pentaho Analyzer document.

    The Pentaho Analyzer document contains details about configuring the visualizations for charts. This document also contains the sample codes for configuring different types of charts.

    NoteYou can also access the CCC (Community Charting Components) playground and documentation for more sample codes to configure required visualization of charts. The link to the CCC playground is available in the Pentaho Analyzer document.
  2. Copy the sample code to the View configuration rulesfield, and modify as required.

    GUID-1BC72605-5DDB-403F-8061-730492BB21B2-low.png
  3. Click Apply, and then click OK.

    The changes are applied, and the visualization of the chart is updated as per the configured code.