My data here corresponds to Kindergarten screening in our school, where pre-K students are evaluated on their ability to recognize letters.
So I have student data coming in, with a field titled MissedCapitalA, that can have a value of either 'y' or 'n'. ('y' if they missed it, 'n' if they didn't.)
I also have the same kind of fields for each letter in the alphabet (MissedCapitalB, MissedCapitalC, ..., MissedCapitalZ).
I'd like to create a chart, with the count of missed letters, (all fields with values = 'y' basically), for each letter, along the x-axis (dimension), and the total number of students who were tested on the y-axis (expression).
Any ideas? Thank You.
Also, I do have a StudentNumber for each student, and I'm trying to use a numeric count of StudentNumber as my Expression for the chart.
your best option, in my opinion, is to use CROSSTABLE load and transform all your separate fields b letter into a set of two fields - "Letter Missed" and "Missed Flag". You can also transform your "Y" into 1 and "N" into 0. This way, the chart becomes trivial - your dimension will be "Letter Missted" and the expression will be "Sum([Missted Flag])"
