How to create a Pie Chart in Spotfire from a calculated aggregation of raw data?!

[Jeff Hanson---LEFT]

I have a data set of several production batches that includes multiple test parameters and the results for many units. I've created a cross table with a custom expression to calculate and bucket (Red, Yellow, Green) into a column. This works fine. However, I want to create a pie chart with slices for Red, Yellow, Green.

I can't seem to find the magic approach!

Help is appreciated.

thanks!

[Gaia Paolini]

could you provide a sample dataset and details on your custom expressions and pie settings?

[Jeff Hanson---LEFT]

This is the cross table...

This is the custom expression for the "CpkGroup"...

Case when (Min(Abs(Min([uSL]) - Avg([TestResultValue])),Abs(Avg([TestResultValue]) - Max([LSL]))) / (3 * StdDev([TestResultValue])))>=1.67 then 'Green' 

when (Min(Abs(Min([uSL]) - Avg([TestResultValue])),Abs(Avg([TestResultValue]) - Max([LSL]))) / (3 * StdDev([TestResultValue])))<1 then 'Red'

Else 'Yellow' END as [CpkGroup]

[Gaia Paolini]

have you tried using the same custom expression, surrounded by <..> to Color By in the pie chart?

[Jeff Hanson---LEFT]

Yes, I have.

I think the problem is related to creating the pie chart based on a custom expression. I cannot create the pie chart in the first place. Next I will worry about how to change the colors. :-)

[Gaia Paolini]

can you try this: create a bar chart, then right click on properties and choose 'switch visualization' to a pie chart?

[Jeff Hanson---LEFT]

I have tried that also. When I use the expression that bins the Cpk's into colors as the category axis all I get is this...

[Gaia Paolini]

looks like the problem is related to the data..any chance you can upload a sample dxp?

[Jeff Hanson---LEFT]

I can't do that publicly but can I send privately?