Jump to content

Pie Chart from Yes/No data in one field


Jason H

This topic is 3305 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 !!

Link to comment
Share on other sites

This topic is 3305 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.