Percentage label display on bar chart

[Former Member]

I've created a stacked bar chart. One of the values I'm displaying is the distinct count of records per group, the other value is the percentage of the grand total that is represented by the distinct count. I want to change the display of the percentage from a "number" to a percentage, but when I right click the data label and select Format Data Label, and choose Percent on the number tab (with 0 decimal places), it changes from 30 to 2,956%. Now the actual percentage is 29.56%, so it seems to be calculating correctly, but misplacing the decimal.

Any help getting this to display 30% instead of 2956% would be greatly appreciated.

[former_member260594 · Accepted solution]

Because when you select to display the value as 100% format it is converting the value to a percentage by multiplying by 100. Unfortunately when you select to displauy as a percentage of the grand total it is also converted to a percentage but without the % sign.

The workaround this would be to create a formula to calculate what the value would be of

distinctcount (, )/ distinctcount ()

Insert this as the show value field in the chart and enable the Don't summarize option.

Set the display value to 100%.

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly

[Former Member]

I have a follow-up question to the answer to my original question.

[Former Member]

Thank you SO MUCH for that idea, it fixed one of my problems, I had given up and was going to educate my users that it was a percentage.

The other problem I have is on my report, I have the need to display a chart similar to the one you helped me with, but based on a different group. My report is showing incidents raised by customers per region, district, and cost center. Some of the incidents result in fees being refunded, but the fee is not always charged to the same cost center as the one the incident was raised against.

I have grouped my report based on the Region, district and cost center that the fee was charged to, but I need a chart that shows the same breakdown by incidents raised. Is there a way I can perform the calculations without adding another group to my report for the same thing? The summary functions all require a group name, and if I add the other group name, my report navigation gets duplicated. I could add a subreport on the chart, but I'd like to learn if there's a way to add this group, but not have it show up on the navigation, or perform the calculations without having to add the group.

I hope this makes sense. Also, I don't see where you specify the display value you mentioned.