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).
Reference: Configure a Combination Chart into a Pareto Chart https://community.spotfire.com/articles/spotfire/configuring-combination-chart-pareto-chart/
Comments
0 comments
Article is closed for comments.