Percent

The Percent field is a numerical field that stores percentage values. Use it for data such as completion rates, discount percentages or performance metrics.

Create a Percent field

1. Click the + icon next to the last field in your table.
2. Enter a name for the field.
3. Select Percent from the list of field types.
4. (Optional) To show the percentage as a progress bar, turn on Display as progress.
5. (Optional) If Display as progress is on, select a Progress bar shape: Bar (default) or Circle.
6. (Optional) Set a default value for the field.
7. (Optional) Add a description.
8. Click Save Field. NocoDB adds the field to your table.

Refer to the general guidelines on creating a field.

Progress bar shape

When Display as progress is on, a Progress bar shape dropdown shows. It sets how the cell shows the progress:

• Bar (default) shows progress as a horizontal bar.
• Circle shows progress as a circular ring.

This image shows the two shapes side by side:

Cell display

The Percent field shows as a numeric cell in the table. The cell is right-aligned by default.

• When Display as progress is on, the value shows as a progress indicator. The indicator is a horizontal Bar or a Circle, as set by the progress bar shape.
• When Display as progress is off, the value shows as a standard percentage.

Good to know

• You enter values as whole numbers. NocoDB shows them with a percentage sign (for example, 75 shows as 75%).