Hi Lendi Kee,
Data manipulations like these are not directly related to the operation of the RadChart control -- as we have noted in our previous reply RadChart does not perform any modifications on the passed data therefore we do not provide suitable tutorials on the topic. Still, the approach you have already outlined (COUNT and GROUP BY operators) seems like a logical solution for this scenario.
the Telerik team
Check out Telerik Trainer
, the state of the art learning tool for Telerik products.