Spotfire Ideas Portal
Make it possible to create a pareto chart. That is, the special configuration of bar chart where:
* Bars are sorted in descending order.
* A line shows the cumulative totals (percentage) of each category, left to right.
http://en.wikipedia.org/wiki/Pareto_chart
Still, it would be nice with more options for curve drawing in bar charts.
And, since pareto chart is such a well known special case of a bar chart/line chart it could perhaps make sense to have it as an Appearance option in the proiperties dialog of the bar chart?
| Implemented in | 11.5 |
Pareto chart is now available as a visualization mod for Spotfire from the TIBCO Community Exchange: https://community.tibco.com/s/exchange/aCv4z000000kPt1CAE/pareto-chart-mod-for-tibco-spotfire
To use the Pareto Chart Mod, Spotfire 11.5 or later is required.
I would love for a standard Pareto chart to become available. The current solution (with the combination chart) has a bug: if you have 2 bars with the same height, the cumulative percentage will act weird and go down. After struggling with that for over a year, I still do not have a solution for it.
See this article about how to configure a pareto chart using a spotfire combination chart: https://community.tibco.com/wiki/configure-combination-chart-pareto-chart
Link posted by Niklas is broken. I'm manually trying to create pareto chart using combination chart with Sum(Y1), cumulativeSum(Y1) as axis selectors & X axis as category variable. The problem is if sort my Xvariable, the bar graph gets sorted but the line chart is zigzag (not expected for cumulative sum). Attached screenshot for reference.
The challenge of using a bar chart with line from column values is that X variable needs to be numerical. Defeats a strong usecase of Pareto to compare imbalanced categories.
John, thank you for your comment. It is actually possible at some level to create a pareto chart (while not as straightforward as one might want). Please look at this video: http://d29fi159bvkn8i.cloudfront.net/QRT/v5.5/YI779/presentation.html
Does it cover what you need or is something missing - please let me know.
Also all others that voted for this Idea please comment.
Seems like the contribution here is the cumulative totals (percentage) line overlaid on the sorted bars, since the sorted bars can be accomplished today. Having the ability to easily switch on/off the cumulative totals would be a significant contribution.