Chart Options for Analyzer reports

Archived. Content merged into "Creating Analyzer reports".

circle-info

This page is archived. The current instructions are in Creating Analyzer reports.

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

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

General tab in Chart Options

Fill in the following options:

Option
Description

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

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

Axis tab in Chart Options

Fill in the following options:

Option
Description

Primary Axis

Auto 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 Axis

Available for Scatter and Column-Line Combo charts only. Secondary Axis has the same options as Primary Axis.

Legend tab

Use the Legend tab to customize the legend.

Legend tab in Chart Options

Fill in the following options:

Option
Description

Show legend

Clear this box to remove the legend from your report.

Position

Use the drop-down to move the legend to the Top, Right, Bottom, or Left of your report.

Background color

Use this to change the background color of the legend. Click on the Background Color box to bring up the color picker.

Font

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 of the legend.

Other tab

Use the Other tab to tailor the look of small charts (multi-charts). You can also control how Analyzer shows empty cells.

Chart options Other tab

Fill in the following options:

Option
Description

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

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

circle-info

Configuration rules use JSON syntax.

Advanced tab in Chart Options
  1. Click the Help icon icon to open the Pentaho Analyzer document.

  2. Copy the sample code into View configuration rules, then modify it.

  3. Click Apply, then click OK.

Set default chart options

As an administrator, you can set default chart options that apply whenever a new chart is created. Defaults do not apply to existing charts.

You can reset a chart back to default settings by clicking Reset to default on the Other tab of the Chart Options dialog box.

Role permissions are as follows:

Actions
Administrator
Power user
Business analyst (View-only)

Set

X

Reset

X

X

Remove

X

To set a default chart option:

  1. Open the chart you want to modify.

  2. Select More actions and options, then click Chart Options.

  3. Set the options you want, then select Set as default for all charts.

  4. Click OK.

Last updated

Was this helpful?