Pie Charts 1

[scoob28]

I'm having trouble making what I beleive is a simple pie chart. I have the following data.

Year 2005

Run Items Produced
--- ----------------
1 300
2 150
3 100
4 0

A run is successful if it produces anything over 0 items. I want to create a pie chart showing the precentage of successful and unsuccessful runs. In this case, 75% of the chart would be green and 25% would be red. I do not want each run labeled separately. I want them grouped into either successful or unsuccessful. The colors I can handle. It is getting just two things graphed, successful or unsuccessful, which is giving me problems.

Thanks

 

[lbass]

Create a formula:

if {table.itemsproduced} > 0 then "Successful" else "Unsuccessful"

Use this as your "on change of" field, and use ocunt of table.run as your summary field.

-LB

 

[scoob28]

Thanks lbass!