Pretty new to the new charts within SSRS, trying to do my first one with percentages. My logic actually outputs the percentages by default, but the pie chart isn't presenting them properly.
My data set has two values: Media Type, Percent
In Chart Data, the Percent is in values section, the Media Type is in the Category Groups.
I have right-clicked my pie chart and selected 'Show Data Labels'
I have right clicked one of those labels and made the Label Data #PERCENT.
I think it is because of the number of slices. The logic posted below returns 11 records.
While in design pane, the data is accurately represented, but it only shows six slices.
When I preview, all eleven or grahically represented, but they're all the same size, and they're all tagged 9.09%.
screen shots of both are attached.
m.[Description] [Media Type],
[Percent %] = convert(VARCHAR,convert(MONEY,100.0 * COUNT(MediumID) / (SELECT COUNT(*) FROM dbo.CampaignDetails)),1) + ' %'
dbo.CampaignDetails c JOIN dbo.MediumTable m
ON c.MediumId = m.[Id]