Pie chart under 100%

Question

Pie chart under 100%

PHXHoward

SSCrazy Eights

Points: 8389
More actions
October 8, 2010 at 5:23 pm

#241397

Hello and good day,
My task is to record supporter utilization so I made a table that shows
SupporterID, ProjectID, DailyUtilizationPercentage
Each supporter will have multiple projects so it might look like this:
Supporter1 Project1 20
Supporter1 Project2 40
Supporter1 Project3 30
Supporter1 Project4 10
Supporter2 Project1 40
Supporter2 Project2 40
Supporter2 Project3 10
Supporter2 Project4 10
Supporter3 Project1 50
Supporter3 Project2 20
I made a report that shows a pie chart with the percentages that supporters spend on each project. Supporter3 is not fully utilized but the pie chart does not reflect the part of the day when they are not working on a project. Is it possible for SSRS to maintain the correct percentages visually by showing unused space as a piece of the pie chart instead of stretching the other pieces to fill the chart?
Thanks for reading,
Howard

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Doug Lane SSCrazy Points: 2118 More actions · Answer 1

I think the RS pie chart always deals with 100%. One workaround is to have your query append a new row if the sum of a group is < 100%. Also, you could have the chart check for the name "Unused Time" or whatever and format the slice as white/transparent so it gives the appearance of vacant time.

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 2

Thank you Doug. That is what I would like to do. I may need help setting it up.

Howard

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 3

I got this working by creating a union query that adds a row that is 100 - sum(utilization). Not sure if there is a better way.

Thanks for your suggestion Doug.

PHXHoward SSCrazy Eights Points: 8389 More actions · Answer 4

This is working now but I would like to make the unassigned slice white/transparent. The color pallet is bright pastel.

I thought of something like this as an expression but can't figure where it should go.

=IIF(Fields!ProjectName.Value = "Unassigned","Transparent","Nothing")

Any advice on how the expression should be formatted and where it should go in the chart properties?

Thanks a lot,

Howard

EDIT: I'm using SSRS 2008

peterzeke SSCrazy Eights Points: 9003 More actions · Answer 5

Just a quick FYI -- avoid using pie charts as a visual means to display data; better to use bar charts. Here's a link to an excellent article on Stephen Few's website (perceptualedge.com) explaining the pitfalls of pie charts: