Skip to main content

Cumulative percentage line in Pareto chart is not summing correctly for the filtered out data

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

Cumulative percentage line in Pareto chart is not summing correctly for the filtered out data


Solution:

When creating a Pareto chart per the referenced Wiki article, the cumulative percentage line sums correctly when no filters are applied. However, when the data is filtered out, the line does not have a 'smooth' cumulative rise and instead shows a jagged appearance. Refer to the attached (Filename: Unsmooth.PNG). The reason for this un-smooth line is because the x-axis expression is evaluated on all data and not on the filtered data.

To resolve this behavior, set the following.

  • Properties > X-axis > Settings > Evaluate axis expression on: "Current filtering only" instead of default "All data".
Refer to the attached files for reference. (Filenames Smooth.png). Wiki: Configure a Combination Chart into a Pareto Chart

Related articles

Comments

0 comments

Article is closed for comments.