This content has been marked as final.
Show 2 replies

1. Re: Calculating % of students in each quartile  Bottom two quartiles below xaxis
Tracy Rodgers Jun 19, 2012 3:28 PM (in response to Cole Pacak)1 of 1 people found this helpfulHi Cole,
I think what you are referring to when you say it goes haywire is the labels on the bars? If this is the case, place sum(Number of Records) on the label shelf instead of Counts by Quartile. Then, right click on it and select Quick Table Calculations>Percent of Total. Right click again and select Compute Using>Table (Down). Then, right click on one of the labels and select Format... and format the labels as desired. I hope this helps!
Tracy

2. Re: Calculating % of students in each quartile  Bottom two quartiles below xaxis
Tim Lens Jun 21, 2012 11:15 AM (in response to Cole Pacak)I guess you also want your axis and bar heights to represent percentages, and not just the labels.
In that case you'll need to put your table calc before you do the multiplication ( * 1 )See the workbook attached, I copied your calc and put the table calc inside already.
Hope that helps.
Working with Quartiles.twbx.zip 64.4 KB
