Percentage of Eligible vs No Eligible

[Anonymous]

I have a table on my page, and in a separate section I want to indicate the percentage of plants that met the Eligible category.  Eligible is just anything over 98%.  What would be the easiest way to do this?

[Anonymous]

Hey @Anonymous 

Create a calculated column.

Eligibility = IF(order_accuracy > 0.98, "Eligible", "Not Eligible")

Thanks!
A

[Anonymous]

---

Thanks .  I do already have that calculation, which is how I got the last column.  

What I'm trying to figure out is how to convert those to a percentage, like in a pie chart.

So if I have 20 locations and 6 are not eligible I want to list it as a pie chart with 30% in the red and 70% in the green.

[Anonymous · Accepted solution]

Hey @Anonymous 

Format your column as percentage.

Cheers!
A