August 27, 2013 at 2:08 pm
Hi ,
I have 2 columns Business_Hours, Billable_Hours in My SSRS and i am planning to make Pie Chart with this 2 values, by considering Business_Hours as 100%. and showing the Billable_Hours on it .
In values pane i was following expression
as =((Fields!Business_Hours.Value)/(Fields!Business_Hours.Value))* 100 by adding Business_Hours Column.
Then in Category Groups Pane i was adding the column Billable_Hours and under category Group Properties in Group Expression i was using the expression
=((Fields!Billable_Hours.Value)/(Fields!Business_Hours.Value))* 100
but i was getting the pie chart result with whole one color as Billable_Hours
Could some one help me in achieving this task .. thanks i advance
August 28, 2013 at 4:45 am
Pie charts have to have at least two measure points to work. In this cases you only have 1. If you want the pie chart to show the "slice" of billable hours and then fill in the rest with the business hours, you will need to a "category" that flags a row of data as either billable or business. From how you describe the data, you probably will need to add some sort of calculated measures / field to create this flag.
August 28, 2013 at 7:37 am
Hi I need to show % of Billable Hours in different colors like if the % of Billable Hours is >90% then Red and Billable Hours < 90% then Green and Billable Hours = 90% then Yellow considering the whole pie chart as 100% for Business Hours. So could you please guide me step by step in achieving this task . I was getting single block with only one color and showing me the Billable_Hours as 85.29 value side to the pie chart . I do not know where i was going wrong ...? can some one help me in step by step .. Thanks in advance
My Data Set Values:
Business_Hours =6880.00
Billable_Hours =5858.50
In Pie Chart:
-->In value Pane i was providing the Business Hours with expression :
=(Sum(Fields!Business_Hours.Value)/Sum(Fields!Business_Hours.Value))*100
In Category Group Pane i was providing the Billable Hours and Category Group Properties i am setting the label Expression as below
=((Fields!Billable_Hours.Value)/(Fields!Business_Hours.Value))*100
August 29, 2013 at 7:23 am
Your category value must be some sort of flag, not a measure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply