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

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

book

Article ID: KB0083341

calendar_today

Updated On:

Products Versions
Spotfire Analyst All Versions

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

Attachments

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