Percentages for rows / columns
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Considering within row / column
Above, we created the "Renovated?" column that determined whether or not the student's information was pre or post Coding for Crammers renovations, which occurred in 2020.
Out of each Primary Focus, let's show the percentage of students involved pre and post renovations.
To do so, place Primary Focus in "Rows" and the Renovated? field in "Columns". Then, place the "First" field in "Values", because each student has a first name.
Notice how currently, we're seeing the count of students in each Primary Focus pre and post renovations. We want instead to see the percentage of students pre and post renovations involved in each Primary Focus, respectfully.
To do so, click the "i" icon next to "Count of First" in the "Values" section. Then, in the pop-up box, select "Show data as" and select the "% of Row Total" option.
Now, we're able to see the percentage of students enrolled pre and post renovations, in respect to each Primary Focus.
Considering all records
What if instead, we wanted to see the percentage of students enrolled pre and post renovations within each Primary Focus in respect to the entire student population?
Click the "i" icon next to "Count of First", then "Show data as". This time, select the "% of Grand Total" option.
Notice how each row doesn't result in a sum of 100%. That's because each percentage is now in respect to the entire student population, not just the students within each Primary Focus.
Multiple percentage calculations are available for each field. To access, press the information button next to the field, select "Show data as", and select your desired calculation for percentage