Customize PDI Data Explorer
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
Procedure
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.
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 } }, */
Remove the
/*
marker and the*/
marker to uncomment the EntityWithTimeIntervalKeyStrategy command.Save and close the file, then refresh the browser.
Results
Set discrete axes for number dimensions in PDI Data Explorer
Procedure
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.
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 } }, */
Remove the
/*
marker and the*/
marker to uncomment the EntityWithNumberKeyStrategy command.Save and close the file, then refresh the browser.
Results