I am afraid RadChart will not support this kind of data manipulation. Grouping in RadChart is described in this help topic
. Note, that grouping in RadChart results in items grouped in series, while the item values are still the ones from the datasource. You will need to query your data, so that the count is present and send the modified view to the chart.
the Telerik team