Pie chart for column sum

ronhab

Hi,

I have a dataset with records like that:
studentName, correctAnswers, totalAnswers

I want to create a pie chart with only 2 slices - 1 for the sum of correct answers (for all students) and 1 for the sum of incorrect answers (which are totalAnswers-correctAnswers).
How can I do it?

Thanks,
Ronen

thuston

You need to split each row into two rows.<br />
<br />
studentName, correctAnswers, totalAnswers<br />
'ronhab', 80, 100<br />
<br />
studentName, slice, numAnswers<br />
'ronhab', 'correct', 80<br />
'ronhab', 'wrong', 100-80<br />
<br />
<br />
Do it in your SQL query or by using two DataSets and then the <strong class='bbc'>Union</strong> DataSet to merge them.