Skip to main content

Pentaho+ documentation has moved!

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

 

Hitachi Vantara Lumada and Pentaho Documentation

Customize PDI Data Explorer

Parent article

You can customize the PDI Data Explorer as follows.

Use discrete axis for line, area, and scatter charts

By default, the PDI Data Explorer provides time and number dimensions in line, area, and scatter visualizations on a continuous scale axis. The continuous axis is helpful for identifying trends that occur over a period of time, such as financial growth, real estate sales, or test scores.

Prior to Pentaho version 8.1, line and area visualizations used a discrete axis, where the data points display evenly spaced across the axis. Additionally, the scatter visualization only accepted measures in its X-axis and Y-axis zones. However, if you prefer the Time and Number dimensions in Line and Area visualizations on a discrete axis, and to disable the Time and Number dimensions in Scatter visualizations, perform either or both of the following procedures to edit the global mapping configurations:

Set discrete axes for time dimensions in PDI Data Explorer

To display Time dimensions in the line and area visualizations on a discrete axis, perform the following steps:

Procedure

  1. Navigate to the pentaho/design-tools/data-integration/system/karaf/config/web-client system directory and open the config.js file with any text editor.

  2. Locate the Example Rule 9 - Disable the continuous date strategy code block, as shown in this example:

    // Example Rule 9 - Disable the continuous date strategy, to revert
    // to the old behavior (Before 8.1) that represents Time dimensions in a discrete axis.
    /*
    {
      select: { module: "pentaho/visual/role/adaptation/EntityWithTimeIntervalKeyStrategy" },
      apply: { isBrowsable: false }
    },
    */
  3. Remove the /* marker and the */ marker to uncomment the EntityWithTimeIntervalKeyStrategy command.

  4. Save and close the file, then refresh the browser.

Results

Your line and area visualizations will display Time dimensions on a discrete axis and the scatter visualization will not be able to provide Time dimensions.

Set discrete axes for number dimensions in PDI Data Explorer

To display Number dimensions in the line and area visualizations on a discrete axis, perform the following steps:

Procedure

  1. Navigate to the pentaho/design-tools/data-integration/system/karaf/config/web-client system directory and open the config.js file with any text editor.

  2. Locate the Example Rule 10 - Disable the continuous number strategy code block, as shown in this example:

    // Example Rule 10 - Disable the continuous number strategy, to revert
    // to the old behavior (Before 8.2) that represents Number dimensions in a discrete axis.
    /*
    {
      select: { module: "pentaho/visual/role/adaptation/EntityWithNumberKeyStrategy" },
      apply: { isBrowsable: false }
    },
    */
  3. Remove the /* marker and the */ marker to uncomment the EntityWithNumberKeyStrategy command.

  4. Save and close the file, then refresh the browser.

Results

Your line and area visualizations will display Number dimensions on a discrete axis and the scatter visualization will not be able to provide Number dimensions.