Just like we get percentage in Pie chart, I want o create a custom column that calculates percentage. i did followed the (number1/number2)*100 function, but i keep getting errors.
so my columns are admin name, count of payment, paid amount and i want one more column called percentage.
basically i want to show in a tabular report of admin name and paid amount pie chart. how can i do that?
Hi
Pie/donut chart are always plotted in a 360 degree (circle), so intrinsically it can show as percentage.
If you want admin name and paid amount as pie chart, drag pie chart in the “Rows” section, then drag admin name in the “Color” section of the marks. Then select Grid Chart and in the “Marks” section click on “Arc” or “Donut”
You can also refer to this
Thanks for sharing informative insights. 