Show field values in a pie chart

[#1]

Hey guys,

would it be possible to show values of a field in a pie chart and calculate the proportion of each unique field value, even though there is no another table for those values being identified?

Best regards and many thanks!

[avinashelite]

Can you please post the test app.

[#3]

Yes this is possible. Could you pl paste the screenshot.

[#4]

Hey Avinash and Subhranjali,

thank you for your responses.

For example I have a table column type with field values like:

type

a

a

a

b

b

b

c

c

c

I would like to to show the proportion of the value "a", "b", and "c" in a pie chart, which should be in this case 33.3%, 33.3%, and 33.3%

and I don't have another table in the database for identifying "a", "b", and "c"

[avinashelite]

Hi Myriadius,

Please find the attachment for the solution.

Note: After writing the expression go to numbers and select show in %.

Regards,

@vi

[sudeepkm · Accepted solution]

you can show values on the PIE chart data points or in the legends (in case the chart is busy).

For % you can also try enabling "relative" in Expressions. Please take a look at the screenshot below.

[#7]

Thank you all a lot!