TIBCO Spotfire

Hi,

Is it possible to create a pareto chart in Spotfire?

An example could be found here: http://www.vertex42.com/ExcelTemplates/pareto-chart.html

Thanks in advance!

Hi,

yes, just create a calculated column using: sum([Amount]) over [customerID] as [sum]

then rank this column: denserank([sum],"desc") as [rank]

then create a Combination Chart, put [rank] and [customerID] on X and the following calcualtion on Y:

sum([Amount]) OVER (AllPrevious([Axis.X])) / sum([Amount]) OVER (all([Axis.X]))

Format the Y-Axis as percentage and you're there...

Christof

Hi Christof, Thanks for the great example. I am able to adapt it to my own data set.

Thanks for the feedback.

One question I always ask: what percentage of your "users" look at, understand, and drill down/across from a pareto chart and actually draw valuable informatíon from it? I personally think a pareto is a good entry point into an anlysis, but I would like to hear your opinion on it as well.

Kind regards, 

Christof

Hi Christof, In my case it is actually a request from some "users" to setup a pareto chart. They are using pareto chart in production to look at the amount of different defect types. Pareto chart allows them to immediately see what is the level of total defects, the level of each defect type and which defect type is the main problem. At this moment it is not used for drill down. It's a simple and easy to understand chart that compress many pieces of information in a single visualization. Best Regards, Eddy

Thanks for sharing the usecase information.

Best regards,

Christof

Just curious.. do you know of a way of doing this using expressions (vs using a calculated column). Reason is so that the ranking will be recalculated when using filters, etc.

Hi,

yes, you can do it in a scatter plot with counting all-previuous over "Marker", which is the same functionality as a rank...

Integer(Count([Account #]) OVER (AllPrevious([Hierarchy.Marker])))

Does that help?

 

Christof

Hi Christof,

 Seems like you are the guru of pareto charts in Spotfire! I have a similar request - I have a bar chart with oil volumes on the Y axis and categories of production loss on the X axis - I want to be able to order the categories on the x axis dependant on their Y axiz volume.

 Is that possible?

Thanks!

Austin

Can't you just sort bars by value (Properties/Appearance)?

Christof

Christoff - wonderful - I am a spotfire newbie and didn't knwo you could do that. Excellent! Thank you so much!

 Austin

Christof,

Thanks for all that you've shared. They're very helpful.

I tried to build a pareto chart based on your original suggestion. But as you observed in the other thread, the RANK with OVER does not recalculate with filter changes.

I also tried avoid using RANK. And just use SUM and OVER, then sort the bars using "Sort x-axis by" in Appearance. Below is my expression on the Y axis. The first calculation gives the (non-cumulative) amount in Bar. The 2nd calculation gives the cumulative percentage. The problem is once the chart is sorted based on the Bar value, the Percentage cumulative calculation is still based on the original order (alphabetical). Attached is a picture of what it looks like.

Any idea how I can make it work?

Sum([AMOUNT]), Sum([AMOUNT]) OVER (AllPrevious([Axis.X])) / Sum([AMOUNT]) OVER (All([Axis.X])) as [Pct]

Christof, Thanks for all that you've shared. They're very helpful. I tried to build a pareto chart based on your original suggestion. But as you observed in the other thread, the RANK with OVER does not recalculate with filter changes. I also tried avoid using RANK. And just use SUM and OVER, then sort the bars using "Sort x-axis by" in Appearance. Below is my expression on the Y axis. The first calculation gives the (non-cumulative) amount in Bar. The 2nd calculation gives the cumulative percentage. The problem is once the chart is sorted based on the Bar value, the Percentage cumulative calculation is still based on the original order (alphabetical). Attached is a picture of what it looks like. Any idea how I can make it work? Sum([AMOUNT]), Sum([AMOUNT]) OVER (AllPrevious([Axis.X])) / Sum([AMOUNT]) OVER (All([Axis.X])) as [Pct]

HI alee,

Do you work it out?

Can you share you Code or Thinking?

Thanks

Christof, thanks for technical specs on how this is created

Following your instructions on how to create a Pareto chart one issue I had was my sort order on the x-axis (ranking)

DenseRank([BU SUM],"desc") - For some reason its not sorting everything in desceding order?? as you can see rank 4 should be rank 2 etc..? This is the order it sorts my values on the x-axis. Any ideas?

RANK	Sum(COSTFIELDEST)
1	$38.10M
2	$4.41M
3	$5.26M
4	$7.56M
5	$5.18M
6	$3.27M
7	$2.06M
8	$2.07M
9	$1.09M
10	$1.75M
11	$1.08M
12	$663.46k
13	$671.68k
14	$1.16M
15	$725.51k
16	$352.80k
17	$317.09k
18	$314.54k
19	$269.90k
20	$161.66k