Maybe it's my browser but I don't see the pic file.
Blindly then, have you tried testing the SQL result for 0 and nulling it?
William, I forgot to post the pic. How would you null it in that sql statement? Use a if statement in the sql?
Thanks for the pic.
Just thinking of something like this:
$Tr1 = 1;
$Tr2 = 2;
$Tr3 = 3;
$result = ExecuteSQL("
COUNT (Case When MarkingPeriod = ? THEN EventType else Null End),
COUNT (Case When MarkingPeriod = ? THEN EventType else NULL END),
COUNT (Case When MarkingPeriod = ? THEN EventType else NULL END)
WHERE fk_StudentID = ?
AND EventType Like ?"
;"¶";"";$Tr1; $Tr2 ; $Tr3; A_KIPPsters::Apk_StudentID; "%CP") ;
$result = Substitute ( $result ; "0" ; "" )
This is crude and I'm still learning the in's and out's of charts but it appears to me from a quick test that substituting out the 0's from the delimited result list still leaves the element's space on the chart without putting the value.