book
Article ID: KB0083341
calendar_today
Updated On:
Description
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).
Resolution
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).
Issue/Introduction
Cumulative percentage line in Pareto chart is not summing correctly for the filtered out data
Additional Information
Wiki: Configure a Combination Chart into a Pareto Chart