Feature Summary
Multidimensional tables offer a rich set of field types, among which the Percentage type is suitable for specific data scenarios. The Percent field displays values in percentage format and supports decimal precision settings. It is applicable to scenarios requiring percentage display, such as completion rates, growth rates, and proportions. Core features include:
- Supports data formats and validation specific to this type
- Supports use in conjunction with other field types
- Can be used for filtering, grouping, and statistics
- Data content can be exported and shared
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Operation Steps
Creating a Percent Field
Feature Entry
Click the "+" button on the right side of the header → Select the "Percent" field type
- In the data table, click the "Add Field" button (+ icon) on the right side of the header
- In the field type list, find and select the "Percent" type
- Enter the field name as prompted and click "Confirm" to create
- After the field is created, enter data into the cells following the input method for this type
Configuring Field Properties
Feature Entry
Right-click the field → "Field Settings" button → "Number Format" dropdown menu
- Right-click the field and select the "Field Settings" button
- In the settings panel that appears, click the "Number Format" dropdown menu
- Set the display format for percentage values
- Click OK to save the configuration
Frequently Asked Questions
Q1: Can a Percent field be changed to another type after creation?
- Solution: Yes. Select "Change Field Type" in field settings, choose the new type, and confirm. Note: Data anomalies may occur if data formats are incompatible. It is recommended to back up the field data before making changes.
Q2: Can Percent field data be used for filtering and grouping?
- Solution: Yes. Data from all field types supports filtering and grouping, and the Percentage field is no exception, helping you quickly locate and classify records in the data table.
Q3: How can I ensure the Percent field type is correct when importing from Excel?
- Solution: When importing an Excel file, the system automatically identifies and matches field types. If the identification is inaccurate, you can manually modify the field type after import, or adjust the data format in Excel first and then re-import.
Notes
- After creating a field, it is recommended to carefully check whether the input method and format validation rules meet expectations
- Changing the field type may cause existing data formats to become mismatched; please proceed with caution
- Data in this field supports export to multiple file formats, facilitating external collaboration