Pie Chart from Yes/No data in one field

[Jason H]

I'm trying to create a Pie chart that shows how many "Yes" and how many "No" responses I have in my data.

The value of Yes or No is in ONE field across 72 records

 

When I make the chart I get 72 slices (there are 72 records).

 

I appears that I need to summarize the data to have two totals: Yes's and No's.

I tried to make a Summary field to do this but how do I express 2 different values?

 

I wrote a script that totals the Yes and the No values into two global variable but I can't assign two values to the Pie chart.

 

I'm missing something easy here....Help !

 

Jason

[comment]

Try it this way:

 

1. Define a summary field sCount as Count of [ any field that cannot be empty ];

 

2. Set the chart to:

 

LabelData : YourTable::Response

Value Data: YourTable::sCount

 

Use Data From: [ Current Found Set ]

[x] Show data points for groups of record when sorted

 

Make sure records are sorted by the Response field.

[Jason H]

OK..Awesome !

I kept wanting to put the data (my Yes/No responses) into the Value Data area.

 

I also had a weird glitch with my report where it was not summarizing even though it was sorted. It would only show one record in the Body part and I had to scroll to see each record.

 

I deleted that report and made a new one and that fixed that.

 

Placing the chart in the Header and following your instructions have created a working chart :-)

Thanks again !!