How to show values beside legend in pie chart?

[#1]

Hi,

I have dimension and expressions as below in pie chart.

Dimension1: =If(Match([ConsultName],'XX'),[ConsultName])
Dimension2: Status

Expression1: =Sum(Time_in)
Expression2: =Num(Sum(Time_in)/Sum(Total Time_in),'#,##0.00%')

the pie chart is showing percentages in value ate data points. I need the percentage values to display besdie Status legend as well. The Status have values Enter , Leave

Please can anyone suggest me how to set this.

Thanks.

[#2]

Thanks. I have used this in another pie chart. but the user don't want to see others details. instead user wants to see individual ConsultName details.

[#3]

Thanks. I have used this in another pie chart. but the user don't want to see others details. instead user wants to see individual ConsultName details.

[sunny_talwar · Accepted solution]

Not sure why it is showing you 100% for both. Can you share the screen shot?

I have made improvements to the numbers based on your selection. Try this new one attached.

Best,

Sunny

[buzzy996]

tht means in ur pie chart u only need xx details,is't right?

[#6]

sorry I got confused .  earlier one worked fine. Thanks!

[sunny_talwar]

It might have worked, but the new one is better because once you a make a selection in the previous one you will still see a very high percentage for the other status (which won't make any sense). New one has fixed that issue,

Best,

Sunny

[#8]

yes you are right. Thanks.

[#9]

Can let me know please this. when I used the chart in edit reports. the layout of the text beside chart is not showing proper. is there any way we can fix this?

[sunny_talwar]

I don't know a direct way to fix it in the report itself, but You can try moving the those two numbers in the chart itself to be placed at a place where they would align properly on the report.

Sorry I won't be able to give a good answer here, but you might be able to start a new discussion for this and somebody else might be able to give you a better solution.

Best,

Sunny

[#11]

no worries. That's fine.  you helped me how to set values beside chart. Thanks. will do.