Product: TIBCO Spotfire®
Cumulative percentage line in Pareto chart is not summing correctly for the filtered out data
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".