I am using the [Unexcused Absence Count]. Your advice got me to display # of absences by student ID, but I still don't know how to group # of absences and show the # of students that meet the level of absences. Unless I am missing something? I can color code the absence levels, but that's not what I want either. I'd like to display absence levels on the horizontal axis, and # of students that match that level on the vertical axis.
1 of 1 people found this helpful
You can group calc together using an if statement:
if sum([Number of Records])<5 then "1 to 5" elseif sum([Number of Records])<10 then "6 to 10" else "Rest" end
That is what I have done to color code the levels, but I cannot use the groupings on the axis of a bar chart, as far as I can tell.
if sum([Unexcuse Absent Count])==0
elseif sum([Unexcuse Absent Count])==1
elseif sum([Unexcuse Absent Count])==2
elseif sum([Unexcuse Absent Count])==3
elseif sum([Unexcuse Absent Count])==4
else "Five or More"
In the end, I want a graphic that looks something like this (again, horizontal axis as level of absences and vertical axis as # of students):
Thanks Alex. I was able to replicate what you provided. That was very helpful. If you don't mind, could you email me sometime? I would love to have some resources available when (seemingly simple) questions like this come up, although I will continue to use the forums